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


The information in this article applies to:

  • Microsoft Access 2000
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.

MORE INFORMATION

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.
Modification Type:MinorLast Reviewed:7/13/2004
Keywords:kbBidi kbprb KB232059
©2004 Microsoft Corporation. All rights reserved.