Change the Windows regional settings to modify the appearance of some data types

Your Microsoft Windows regional settings will influence how your date/time, numeric, and currency data types appear when you apply formatting options. Windows supports a variety of languages, plus currency and date/time formats for the countries/regions that use those languages.

For example, you might use forward slashes to enter a date value for a Date/Time field (for example, 8/29/2006), but when you apply the General Date display format, it may or may not display the forward slashes, depending on the regional settings for Windows.

This principle also applies to numeric and financial data. You can enter currency amounts that use the English pound symbol (£), but Access may display those values in euros, because that is the currency symbol selected for Windows.

The following procedure shows you how to change the Windows regional settings for your computer.

Change the regional settings

To change regional settings, follow the steps described for your computer's operating system.

In Windows Vista    

  1. Click the Start button Button image, and then click Control Panel.

  2. Click Clock, Language, and Region, and then click Regional and Language Options.

    The Regional and Language Options dialog box appears.

  3. On the Formats tab, under Current format, click Customize this format.

    The Customize Regional Options dialog box appears.

  4. Click the tab that contains the settings that you want to modify, and make your changes. For example, to change part or all of a number format, click the Numbers tab and change the setting that you want.

In Microsoft Windows XP    

  1. Click Start, and then click Control Panel.

  2. Click Date, Time, Language, and Regional Options.

  3. Click Change the format of numbers, dates, and times.

    The Regional and Language Options dialog box appears.

  4. Click the Regional Options tab. Under Standards and formats, click Customize.

    The Customize Regional Options dialog box appears.

  5. Click the tab that contains the settings that you want to modify, and make your changes. For example, to change part or all of a number format, click the Numbers tab and change the setting that you want. For help with an option, click the Help button (?), and then click the option.

Top of Page

Applies To: Access 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language