Euro ? problem

[Malc]

I have just completed a new application which will be used in both the UK
(pounds sterling) and the Netherlands (Euro). The application is written in
MS Access 2000. Throughout the app I have used currency fields in both forms
and reports. I developed the application on a Windows 2000 workstation.

Probably very stupid of me, but I expected Access to replace all the £
symbols with ? symbols when I switch my PC from the UK regional setting to
the Dutch (Netherlands) setting. How wrong was I !

This is the situation.

I have used Tahoma fonts throughout (This is supposed to support the Euro)

Loaded the application on a Windows XP machine set to Dutch - No Euro symbol
Loaded the application on another XP machine set to Dutch- Euro symbols
displayed. (How is this happening)
Loaded the application on a Windows 2000 machine set to Dutch - No Euro
symbol.

I then looked at the application on my Windows 2000 set to
Dutch(Netherlands) and noticed all the currency fields had a format setting
of £#.##0,00;"-£"#.##0,00 I changed the £ symbol for a ? symbol and this
works (I have about 40 fields to change).

I then changed my regional settings back to UK and found that the Euro
symbol was stuck!

HELP - How do I develop an application in Access that can be used across
Europe without having to change all the currency fields every time I ship an
update?

Malcolm.

 

[Brendan Reynolds]

Access will use the currency format from the PC on which the application was
originally developed. To have it use the format from the PC on which it is
running instead, set the format in code in the Open event of forms and
reports ...

Me!NameOfControl.Format = "Currency"

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.