By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,099 Members | 2,156 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,099 IT Pros & Developers. It's quick & easy.

Regional Settings Currency Format

P: n/a
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


Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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 ;-)


Nov 13 '05 #2

P: n/a
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" <me@privacy.com> 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 ;-)

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.