Kingham Software, Inc. : Custom Software Solutions
Home Custom Software Solutions Getting Started Blog Contact Us
Kingham Software, Inc.

 

Mike Kingham's Blog

Microsoft Access does not format currency properly when the computer's region has changed.

by Michael Kingham (posted October 2007)

A Step by Step guide to reproducing the problem

Here are the steps to reproduce the problem descibed in my article "Microsoft Access does not format currency properly when the computer's region has changed".

Step 1) Create a database with a table that has currency fields in it.

Step 2) Create a report based on that table. (Notice how the Format property for the field is set to 'Currency'.)

Step 3) Save the report and close the database. Go to Regional Settings under the Control Panel and change the country to the UK.

Step 4) Re-open your database and look at the format property for the field. It has been changed from 'Currency' to '$#,##0.00;($#,##0.00)'.