Microsoft KB Archive/232020

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

Article ID: 232020

Article Last Modified on 6/29/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.



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: kbprb kbbidi KB232020

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.