Problem with how Microsft Access formats Currency
by Mike Kingham (posted October 2007)
If you create a form or report in MS Access and assign 'Currency' to the format property of the field, Access will use the current region's currency settings to display the number. (That part works just fine!)
Now, if you move the database to another PC with a different region or change the region on the original PC, Access does something really stupid. It will alter the format property on that field from 'Currency' to a hard coded representation of the format of the original region.
continue reading Problem with how Microsft Access formats Currency