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

Article translations Article translations
Article ID: 232059 - View products that this article applies to.
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.

Expand all | Collapse all

On This Page

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.

Properties

Article ID: 232059 - Last Review: October 21, 2013 - Revision: 1.1
APPLIES TO
  • Microsoft Access 2000 Standard Edition
Keywords: 
kbnosurvey kbarchive kbprb kbbidi KB232059

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com