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)?

Thanks in advance,
I miss the microsoft newsgroups,
Mark

Mark Andrews wrote:

I thought the UK used pounds.

Maybe you can do the following with conditional formatting. Anyway,
here's an example using Format from the debug window.
y = 1234567.89
c = "US"
? iif(C = "US","$",IIF(C = "UK","£","€")) & Format(Y,"#,##0.00")
$1,234,567.89
C = "UK"
? iif(C = "US","$",IIF(C = "UK","£","€")) & Format(Y,"#,##0.00")
£1,234,567.89
c = "France"
? iif(C = "US","$",IIF(C = "UK","£","€")) & Format(Y,"#,##0.00")
€1,234,567.89

Would you have any idea why the regional settings do not control how Access
2007 works?
Or is there some trick to getting it to work?

I have currencies in about a thousand places and would rather not have to
build my own function to display
numbers in the proper currency (based on what is setup in my application).
I thought that is why you pick "Currency" as a format?
I wouldn’t need conditional formatting I would just control the formatting
in the query that drives the form/report but I do not
want to do it this way, too much work to change the entire application!!!

The guy I talked to today was from the UK and he said he wanted to use
Euros?

Thanks,
Mark


"Salad" <salad (AT) oilandvinegar (DOT) com> wrote

Mark Andrews wrote:


OK. I thought you had a mixture of records; some US, others Euro, other
pounds.

I did a google search on "access 2007 international currency formats"
Here's one of many links.
http://www.msofficetuneup.com/2008/1...n-access-2007/

Here's on from Allen Browne.
http://allenbrowne.com/ser-44.html

I also did a google search on "access determine current regional
settings". Quite a few links as well.

Looks like you have some reading and deciding to do.

Thank you Allen Brownes article describes what I am seeing perfectly.

Mark

"Salad" <salad (AT) oilandvinegar (DOT) com> wrote

Yes you are right the regional settings do not affect the currency format.
Allen Brown has a nice article describing it (see other post).

It does make sense for certain applications.

Example: My app is for collecting donations, they want to enter everything
in one currency and have all reporting
use one currency. However I sell the program to people all over the world
(well right now I don't because it doesn't work well with other currency
formats).

It doesn't make sense for a shared app (with two users using different
regional settings).

Thanks for your help,
Mark

"Rick Brandt" <rickbrandt2 (AT) hotmail (DOT) com> wrote

Mark Andrews wrote:

I would have to do some checking to confirm but I don't think the Regional
Settings affect currency like that and I think it's for a very good reason.

When you fiddle around with regional settings for date display you are only
affecting how dates and times look. You are not changing their value. On
the other hand one million dollars is not the same value as one million
Euros. It makes no sense to me that an app running on two different PCs
with different regional settings would show different currency units.