Show All

About using numbers and dates in South Asian databases

South Asian numeral formats are used in Microsoft Access 2000 and later version databases as numbers, and in date formats. Since Vietnamese uses Arabic numerals and the Gregorian calendar, there are no special requirements for calculating numbers and only a few differences in displaying formats from what English users would expect— for example, in Vietnamese the currency symbol appears after numbers, commas are used in place of periods in decimal places, and periods are used instead of commas as thousands separators. However, in Thai, Access provides a property that lets you choose whether you want Arabic or Thai numerals.

Numeral Shapes property (Thai only)

Two different representations of digit shapes are used in Thai: Arabic and Thai numerals. You can choose to have the text in controls be specifically Arabic or Thai, or you can let the Microsoft Windows operating system determine the numerals. For more sophisticated error handling, refer to the discussion of the Microsoft Visual Basic for Applications (VBA) Numeral Shapes property.

Dual calendars

The date format used by Access is determined by your system locale setting— for example, to display dates in Thai date format, Thai must be selected as your locale in the regional settings of Windows Control Panel. You can enter date values in both Gregorian and Buddhist calendars in the same database by specifying the applicable calendar.