Microsoft KB Archive/232059

= ACC2000: Currency Symbol in Right-to-Left Data Access Pages Is Displayed on the Wrong Side of the Number =

Article ID: 232059

Article Last Modified on 7/13/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q232059



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
The neutral currency symbols such as $ and euro are displayed on the opposite side of the number in right-to-left (RTL) data access pages.



CAUSE
When a data access page control is bound to a Currency field, values displayed in the control are displayed as text and not as currency values. Because the control has a default right-to-left reading order in RTL pages, the symbol is displayed on the right side of the number according to Unicode algorithm.



RESOLUTION
To display the currency symbol on the correct side, set the Dir property for the control to LTR to change the reading order to left-to-right.



Steps to Reproduce Behavior

 * 1) Start Access and open any database.
 * 2) Click Start, point to Settings, and then click Control Panel.
 * 3) In Control Panel, click Regional Settings, click the Currency tab, and set the Currency symbol box to $, euro, or any other neutral symbol.
 * 4) Create a table with a Currency field and enter a few records
 * 5) On the Tools menu, click Options.
 * 6) In the Options dialog box, under Right-to-Left, set Default direction to Right-to-left.
 * 7) Create a data access page based on the table that you just created, and add the Currency field to the page.
 * 8) View the page in Page view. Note that the currency symbol in the text control is placed on the wrong side of the number; that is, you see 123$ instead of $123.

Additional query words: prb RTL LTR Arabic Hebrew

Keywords: kbprb kbbidi KB232059

-

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

© Microsoft Corporation. All rights reserved.