currency symbol in access 2007
Mark Andrews
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
Salad
> 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 thought the UK used pounds.
> 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
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
Mark Andrews
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" <sa...@oilandvinegar.com> wrote in message
news:iKSdncX5V9y1opXR...@earthlink.com...
> Mark Andrews wrote:
>
>> 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 thought the UK used pounds.
>
>> 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
>
> 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
Salad
> 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?
>
No, have no idea. I might close, then open, the app.
> I have currencies in about a thousand places and would rather not have
> to build my own function to display
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/12/11/currency-in-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.
> 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
>> ? 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
>
>
Rick Brandt
> 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!!!
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.
Mark Andrews
Mark
"Salad" <sa...@oilandvinegar.com> wrote in message
news:_KOdnZJDY5XbypXR...@earthlink.com...
Mark Andrews
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" <rickb...@hotmail.com> wrote in message
news:huamvb$lk6$1...@news.eternal-september.org...