ACC2000: Arabic Currency Values Entered in a New Datasheet Are Saved with Text Data Type (232020)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q232020
Novice: Requires knowledge of the user interface on single-user computers.

SYMPTOMS

If you create a table in Datasheet view so that you can enter data directly, and you manually enter the Arabic currency symbol, when you save the table, the field is saved with the Text data type instead of the Currency data type.

CAUSE

Because the Arabic (Saudi Arabia) currency symbol contains strong Arabic characters, a control character is used to control the layout of the symbol in a field. When you enter this symbol manually, the control character is not added, which results in the field not to being recognized as Currency.

RESOLUTION

To work around this behavior, enter the currency values without the symbol and change the data type to Currency after the table is saved.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Start Arabic Access and open any database.
  2. Click Start, point to Settings, and then click Control Panel.
  3. In Control Panel, click the Regional Settings tab, and set the country to Arabic (Saudi Arabia).
  4. In Access, create a new table in Datasheet view.
  5. In any field, enter a few records of currency values and manually add the Arabic (Saudi Arabia) currency symbol as set in Control Panel.
  6. Switch the table to Design view. Note that the field is saved with the Text data type.
Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kbBidi kbprb KB232020
©2004 Microsoft Corporation. All rights reserved.