Currency Format

[rhounsome]

This is probably the easiest question to answer if you know where to look but I don't.

Working in the UK with Access 2000 I need to set the field in a table to show Dollar $ USD however the only values I have are £ GBP and € as defaults.

Now I thought that I could get this to change if I changed my regional settings but then it occurred to me that if I do that and it changes then surely it would mean that who ever used this database in our global organisation would end up with a currency shown in their own local currency. Whilst this may not seem like a problem it is if you don't realise and quote a figure to someone in your local currency.

i.e. at present the UK £ = nearly $2 USD

So if someone in the UK read the figures and it dispalyed £400,000 and quoted this to a person in the USA when in theory the figure was meant to show $400,000 it could cause all sorts of issues.

Can someone tell me the correct way of choosing $ without it affecting anything else.

 

[bretts]

Rhounsome

I know this isn't much help at all but this is from the Access help file about the format property

Remarks

The Format property affects only how data is displayed. It doesn't affect how data is stored.
Microsoft Access provides predefined formats for Date/Time, Number and Currency, Text and Memo, and Yes/No data types. The predefined formats depend on the country specified by double-clicking Regional Settings in Windows Control Panel. Microsoft Access displays formats appropriate for the country selected. For example, with English (United States) selected on the Regional Settings tab, 1234.56 in the Currency format appears as $1,234.56, but when English (British) is selected on the Regional Settings tab, the number appears as £1,234.56.

Other than what you said, all I can think of is having a text box which puts $ or £ or € in depending on user location but that will open up a whole new can of worms about figure is in what currency etc...

Regards

Brett

 

[rhounsome]

I think I have sorted it.

In the Format Field I didn't realise that you can enter your own format so thats exactly what I did. Found it by accident. Got furstrated and Pressed Shift and 4 and hey presto $ came up and then just using the same format as in excel did $#,##00.00 and it works.

Cheers Brett for Looking.