Access 2007 currency format, Office 2007
Jun 3 2010, 07:17 PM
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,
Jun 3 2010, 09:28 PM
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.
ScreenShot.jpg ( 32.19K )Number of downloads: 32
Jun 3 2010, 09:41 PM
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.
Jun 4 2010, 08:01 AM
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.
|Search Top Lo-Fi||1st April 2015 - 08:22 PM|