Regional Setting Currency

Posted on 2012-08-21
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
    LVL 119

    Expert Comment

    by:Rey Obrero
    try closing your db app, change regional setting then open your app.
    LVL 39

    Expert Comment

    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

    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 39

    Accepted Solution

    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

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

    Thank you

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now