UK to USA Currency format

[Ian]

I have an Access 2000 database written in the UK, this database has many
fields set to Currency, I now want to move this database over to a user
in the USA but my Currency fields still show the UK £ sign.

If I look at these currency fields on my UK PC with it set to regional
UK (not USA) then the fields format settings just say Currency, if I
then add the USA region to my PC and look at the format again it says:
£#,##0.00;-£#,##0.00

I could go through each filed (about 70 of them on different forms and
reports) and change them to:
$#,##0.00;-$#,##0.00

Is there is a way I can force them all to go to USA $ sign?

[Allen Browne]

See:
Currency format lost when regional settings change
at:
http://allenbrowne.com/ser-44.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ian" <ia********@ntlworld.comwrote in message
news:dC*****************@newsfe11.ams2...

>I have an Access 2000 database written in the UK, this database has many
fields set to Currency, I now want to move this database over to a user in
the USA but my Currency fields still show the UK £ sign.

If I look at these currency fields on my UK PC with it set to regional UK
(not USA) then the fields format settings just say Currency, if I then add
the USA region to my PC and look at the format again it says:
£#,##0.00;-£#,##0.00

I could go through each filed (about 70 of them on different forms and
reports) and change them to:
$#,##0.00;-$#,##0.00

Is there is a way I can force them all to go to USA $ sign?

[Ian]

Allen Browne wrote:

See:
Currency format lost when regional settings change
at:
http://allenbrowne.com/ser-44.html

Thanks Allan, seems I can change each Currency text box or write code
for each form, what a choice.

Thanks for your help though.