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

• Microsoft Access 2000

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.

Additional query words: inf prb riyal

Keywords : kbdta kbBidi
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb