Sunday, March 29, 2009

Using the Currency field data type internationally

Today I was reminded of the age old problem of the Currency field datatype in Access not reflecting the current users regional formatting settings as set in the Operating System.

The problem is that by default, Access stores the format as specified on the developers machine and does not change the formatting if an end user has a different currency format set in their regional settings.

Some would see this as expected behaviour. Some would see this as a flaw.

If you consider this is a flaw, fortunately there is a simple fix. Please note: The solution discussed in this article only works for tables, queries and _bound_ form/report controls

Wayne Phillips

No comments: