UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Access 2007 currency format, Office 2007    
 
   
mandrews
post Jun 3 2010, 07:17 PM
Post #1

UtterAccess Guru
Posts: 603



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.

I tried going into control panel and "Region and Language" and switch the
currency symbol to a euro sign.

I then 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:
$#,##0.00;($#,##0.00)

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,
Mark
Go to the top of the page
 
+
KimbleG
post Jun 3 2010, 09:28 PM
Post #2

UtterAccess Guru
Posts: 652
From: Auckland, New Zealand



Mark,
For a Database I designed for an Export company, exporting to many of the main currency countries, I used a tblCurrency table.
I then 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: 29


HTH

Kimbo


Go to the top of the page
 
+
WildBird
post Jun 3 2010, 09:41 PM
Post #3

UtterAccess VIP
Posts: 3,119
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 ","
eg
100.00 is shown as
100,00

Need to think of this when hardcoding any formats to controls.
Go to the top of the page
 
+
mandrews
post Jun 4 2010, 08:01 AM
Post #4

UtterAccess Guru
Posts: 603



Thanks for answers, still wondering:

Why doesn't the regional settings change the currency symbol (when I use "Currency" for the property "format")?

I assume 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?

Mark

PS: I do not need any currency conversions, just format control on what will be entered.
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 20th April 2014 - 01:24 PM