Regional Settings Currency Format

[Bob Dydd]

Hi Everbody

Question

Changing the regional settings ie. from UK to US AUS etc, Access
retains the original currency format that the application was created
in.

So if an mdb that is written on a computer with Regional Settings
Currency Format set to UK £'s , when that mdb is open on a machine
with Regional Settings Currency Format set to US $ or AUS $ it
retains the UK £'s format.

Microsoft has something to say about this but does not offer any
further help on this subject.
http://support.microsoft.com/default...8596#appliesto

I am looking for a way to format currency fields according to the
regional settings of whatever machine the mdb is used on.

I could of course do away with the $ and £ signs altogether, but that
would be the cowards way out ;-)

Any help or pointers appreciated.

Regards Smiley Bob

[MGFoster]

I believe you have to compact the .mdb on a computer that has the
destination's regional settings.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Bob Dydd wrote:

Hi Everbody

Question

Changing the regional settings ie. from UK to US AUS etc, Access
retains the original currency format that the application was created
in.

So if an mdb that is written on a computer with Regional Settings
Currency Format set to UK £'s , when that mdb is open on a machine
with Regional Settings Currency Format set to US $ or AUS $ it
retains the UK £'s format.

Microsoft has something to say about this but does not offer any
further help on this subject.
http://support.microsoft.com/default...8596#appliesto

I am looking for a way to format currency fields according to the
regional settings of whatever machine the mdb is used on.

I could of course do away with the $ and £ signs altogether, but that
would be the cowards way out ;-)

[Michael \(michka\) Kaplan [MS]]

Compact does not change this.

It is entirely intended and by design. If you want to have this prop follow
the regional settings then you must have code modify all of the Format
properties in the app.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
Windows International Division

This posting is provided "AS IS" with
no warranties, and confers no rights.
"MGFoster" <[e-mail]> wrote in message
news:rl******************@newsread1.news.pas.earth link.net...

I believe you have to compact the .mdb on a computer that has the
destination's regional settings.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Bob Dydd wrote:

Hi Everbody

Question

Changing the regional settings ie. from UK to US AUS etc, Access
retains the original currency format that the application was created
in.

So if an mdb that is written on a computer with Regional Settings
Currency Format set to UK £'s , when that mdb is open on a machine
with Regional Settings Currency Format set to US $ or AUS $ it
retains the UK £'s format.

Microsoft has something to say about this but does not offer any
further help on this subject.
http://support.microsoft.com/default...8596#appliesto

I am looking for a way to format currency fields according to the
regional settings of whatever machine the mdb is used on.

I could of course do away with the $ and £ signs altogether, but that
would be the cowards way out ;-)