X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Access 2007 currency format, Office 2007    
post Jun 3 2010, 07:17 PM

Posts: 603
Joined: 21-March 09

I have an Access 2007 database. I would like to make it so it could work
with multiple currency symbols.
Example: In the US they would enter dollars, in UK they might use Euros.
tried going into control panel and "Region and Language" and switch the
currency symbol to a euro sign.
Othen opened my access database and looked at a field I had on a form that
had the format set to "Currency"
and decimal places set to 2.
It still showed dollars and when I switched it to design view the Format
property changed to:
Could someone give me some pointers on the proper approach to make an
application work with different
currency symbols (no currency conversion or anything like that)?
Not looking for code on how to use the format function! Looking to understand why changing the currency symbol in my regional settings does not change the currency symbol in my Access application.
Thanks in advance,
Go to the top of the page
post Jun 3 2010, 09:28 PM

Posts: 652
Joined: 12-June 07
From: Auckland, New Zealand

For a Database I designed for an Export company, exporting to many of the main currency countries, I used a tblCurrency table.
Othen used code to manipulate the correct currency symbol, rate and conversion accordingly.
I found this approach works very well, especially when the various rates change often.
Attached File  ScreenShot.jpg ( 32.19K )Number of downloads: 36

Go to the top of the page
post Jun 3 2010, 09:41 PM

UtterAccess VIP
Posts: 3,245
Joined: 19-August 03
From: Perth, Australia

There are a few posts on here regarding this, but things to keep in mind are some countries, such as France, dont use "." for decimal point, but rather a ","
100.00 is shown as
eed to think of this when hardcoding any formats to controls.
Go to the top of the page
post Jun 4 2010, 08:01 AM

Posts: 603
Joined: 21-March 09

Thanks for answers, still wondering:
Why doesn't the regional settings change the currency symbol (when I use "Currency" for the property "format")?
Oassume I have to use a table defining currency formats and the user selects one and on every field on every form and report etc... I have to use a custom function to do the formatting based on what format was choosen?
Is this the only way to approach it?
PS: I do not need any currency conversions, just format control on what will be entered.
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    20th February 2017 - 05:37 PM