Currency (1 Viewer)

[Steve]

I have created a table that contains currency fields, when bound to a form the currency displayed is that set by regional settings. ie dollars or pounds etc ( The field form format is blank). That all works fine, as does it with the reports. But when I view the same data in a combo box or a table the currency shown reverts to £'s allthough the PC's regional settings, all forms and reports show $. Is there a way around this and where have I gone wrong. The table was created on a PC set to £

Thanks

 

[Graham T]

Steve

You can set the format for each combo box on the Format tab of the property for each control in form design.

Graham

 

[Pat Hartman]

I came across this article today and it explains the problem and offers a solution.

Global Appeal

 

[Steve]

Answered

Thanks Pat, yes it contained the answer, not maybe what I wanted to hear! Shall now just have to remove the currency fields from the combo boxes. It would have been nice to leave them in but not essential.

Cheers

Steve