Controlling international data display formats

Microsoft Access can display a wide range of international formats. To help ensure consistency among applications, Microsoft Access uses the regional settings specified by double-clicking Regional Settings in the Windows Control Panel for the predefined Number and Date/Time formats listed in the following table.

Microsoft Access
gets the format for
From this tab in the Regional
Settings Properties dialog box
Standard (and other number formats except Currency) Number tab
Currency Currency tab
Short Date Date tab
Long Date Date tab
Long Time Time tab

If your data isn't displayed in the right format for your country, change the regional settings specified in the Control Panel.

Note   Transferring data between computers with different regional settings can result in incorrect currency data. For example, when using the Currency format, a value of 5,47 kr on a computer set for Denmark converts to $5.47 on a computer set for the United States. To prevent such errors, define a custom format for the currency, such as #,## kr. The custom format overrides the regional settings specified in the Windows Control Panel. Similar problems won't occur when transferring standard number, date, or time data between computers with different regional settings.