I (a British developer) have a database that I am developing for a client in the USA. When I set columns as currency they display with a £ sign. How do I change this so that Access displays a $ sign for currency fields in this database?

Note that I don't want to change my own regional settings if possible.

  • Unless you are also storing what type of currency it is, what does it matter, if it displays as £ or $ on your local copy? If your not willing to change your regional settings then you can't change it locally. – Ramhound Nov 8 '16 at 18:03
  • It also displays as £ on the client's copy. I had assumed it would respect his settings but apparently not. – Jamie Bull Nov 8 '16 at 18:04
  • You are 100% the regional settings on the client's machine isn't already correct? custom currency symbol in access 2010 Bing Search – Ramhound Nov 8 '16 at 18:12
  • I'm not 100%, no, but I'd be very surprised if a guy in Michigan who uses Access and Excel regularly has his local currency set to £s. I will check with him though. – Jamie Bull Nov 8 '16 at 18:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.