M
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.
(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.