By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,083 Members | 1,957 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,083 IT Pros & Developers. It's quick & easy.

UK to USA Currency format

P: n/a
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?
Sep 11 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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?
Sep 11 '08 #2

P: n/a
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.
Sep 11 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.