[Last Call] Learn how to a build a cloud-first strategyRegister Now


Regional Setting Currency

Posted on 2012-08-21
Medium Priority
Last Modified: 2012-08-21
I am having problems with Regional Setting Currency.

I set a form controls property to currency and when I change the Regional Setting Currency from £s to Euros the Format Property changes for the control to Euros and will not change back. All this is happening when I am in form view not design. Going from Euros to £s sometimes gives £#,##0.00;-£#,##0.00  in the format property. How do you get the controls format to stay in line with Regional settings?
Question by:DatabaseDek
  • 2
  • 2
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38316020
try closing your db app, change regional setting then open your app.
LVL 40

Expert Comment

ID: 38316051
I don't like idea to have relation between currency in DB and regional settings if there could be more then one currency. You should have separate field for currency.

Author Comment

ID: 38316226
That is a good idea. Do you mean select currency and then set all currency fields to the selection?

As in (Control) Format = cmbCurrency?

I have no idea what was happening above. When I selected a number of controls together, and set format property, it caused the fault above. when I select them individually and set format it all works?????????????
LVL 40

Accepted Solution

als315 earned 1500 total points
ID: 38316384
I'm adding table with possible currencies and currency symbols. In all records I have value field and currency field. You can select your default currency on user base, for example.

Author Closing Comment

ID: 38317283
Your post didn't answer the question, but offers an alternative option. Very useful tip

Thank you

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question