RE: Regional settings modification

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
.

Relevant Pages

  • RE: Regional settings modification
    ... Country Text Indexed ... This application is intended for different countries and differend currency ... They are still derived from the regional settings. ... simply copied the pound symbol and used it in the format property for text ...
    (microsoft.public.access.modulesdaovba)
  • Re: Regional settings modification
    ... 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. ... 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. ... "Rob" wrote: ...
    (microsoft.public.access.modulesdaovba)
  • Re: change $ to £ in time and billing database template
    ... Assuming that your regional settings are correctly set for your local, ... specifically the section labelled 'Currency ... Format' ... ... and choose the option 'Update Format everywhere BillingRate ...
    (microsoft.public.access.gettingstarted)
  • Re: Trouble with date format
    ... specified as the date separator in Regional Settings. ... Doug Steele, Microsoft Access MVP ... I have a query that returns a date. ... Norwegian format, and the format that is goven for short date in my ...
    (microsoft.public.access.formscoding)
  • Re: NumberFormat does not change the label format
    ... In fact nothing in the regional settings seems to have any affect on ... the format of the graph dates. ... With axis type set to chAxisGroupingTypeNone, ...
    (microsoft.public.office.developer.web.components)