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.