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

This article was previously published under Q232059
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.

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.
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.
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 thecurrency symbol in the text control is placed on the wrong side of the number; that is, you see 123$ instead of $123.
prb RTL LTR Arabic Hebrew

Article ID: 232059 - Last Review: 10/21/2013 22:12:08 - Revision: 1.1

Microsoft Access 2000 Standard Edition

  • kbnosurvey kbarchive kbprb kbbidi KB232059