Re: Regional settings modification
- From: "Alex Dybenko" <alexdyb@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 17 Jan 2007 16:23:59 +0300
Hi Rob,
I also came to this problem once, but did not find any good way to solve this completely.
I am trying to avoid using Currency format, I use "standard" format instead, which do not show any currency symbol, and if symbol required - I showed it in a separate field (user can select a favorite one, like Tom suggested).
as for decimal symbol - I think there is no way to solve this, unless you change regional settings, what, as Doug mentioned, is A Bad Thing. Just imagine - user have comma as decimal separator, and he enter it in any program, so he will try to do in yours, but it will not accept it (if you change it to dot), user will certainly stop using your program.
--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com
"Rob" <Rob@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:B0070E8F-2FAB-4852-98D6-0135E71617B7@xxxxxxxxxxxxxxxx
Hello Tom, thank you for replying
I do not think it is as simple as that (alltough i would like it to be so....)
Let me explain a bit more:
I have an application with about 900 money form fields over 90 different
forms.
This application is intended for different countries and differend currency
symbols.
I know how to achieve the correct formating using the locale regional
setting and with Me![fieldname].Format = "Currency" one can apply those
settings.
But now i was contacted by a user who has an english regional setting (and
want's to keep it) and who would still like to get values in the fields like
1 000,00 € for instance without changing his regional settings. Changing his
settings also affects his other applications and he has to switch over all
the
time.
Meanwhile, other users want to have 1 000,00 FrS for instance....
So i defined a public variable 'moneyunit' to represent the currency symbol
and changed my format statements as follows:
Me![fieldname].Format = "#,##0.00 " & moneyunit & ";-#,##0.00 " & moneyunit
& "; ; "
Ok so good, but now the thousand separator symbol and decimal symbol are
giving me: 1,000.00 € with english regional settings and not 1 000,00 €.
They are still derived from the regional settings.
So i was wondering if it is possible to define ones own money formating
string or to influence the regional settings on startup and set it back to
the original country afterwards.
Any suggestion?
Rob
"Tom Wickerath" wrote:
Hi Rob,
I don't think there is any need to change the regional setting to accomplish
this. I live in the US, where $ is the currency setting. A few years ago, I
helped on an Access application for the Merceyside Police Dept. in England. I
simply copied the pound symbol and used it in the format property for text
boxes. It worked just fine. For example: Format: £ 0.00
Tom Wickerath
Microsoft Access MVP
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
"Rob" wrote:
> Hi all,
> to follow up on a still open question about currency formating, could
> someone tell me if it is possible to change the computers regional > settings
> form currency with vb-code on startup of an Access2003-application and > set it
> back again when quitting?
>
> This is to achieve a customised currency format that would not imply
> permanent display changes for other applications (unless they are run
> simultaniously).?
>
> Many thanks in advance
> Rob
.
- References:
- RE: Regional settings modification
- From: Rob
- RE: Regional settings modification
- Prev by Date: Filtering subform
- Next by Date: Re: Interacting forms
- Previous by thread: RE: Regional settings modification
- Next by thread: Re: Regional settings modification
- Index(es):
Relevant Pages
|
