ACC2000: Euro Symbol Displayed Incorrectly in System Message Box with Some Default System Locale Settings

ID: Q232166

The information in this article applies to:

Microsoft Access 2000

NOTE: This article discusses complex scripts functionality. Complex scripts functionality is available when you use the Office Language Settings tool to enable a language, such as Arabic or Hebrew, that requires this functionality. For more information about multilingual features, click Microsoft <your Office product> Help on the Help menu, type multilingual features in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

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

SYMPTOMS

The euro currency symbol is displayed with a character other than the euro symbol when it is displayed in a system message box.

CAUSE

When the default system locale has an Arabic, Hebrew, or other non-English setting, the MS Sans Serif font for that locale is used for display purposes in message box text. Most of these fonts do not have the euro symbol, which results in a different character being displayed.

RESOLUTION

To work around this behavior, change the system message box text to a font that contains the euro symbol. To do so, follow these steps:

Click Start, point to Settings, and then click Control Panel.

In Control Panel, double-click Display.

Click the Appearance tab.

Under Item, click Message Box.

Change the font setting to any font that contains the euro symbol, for example, Arial, Courier New, Times New Roman, or Tahoma.

MORE INFORMATION

Steps to Reproduce Behavior

In Control Panel, double-click Regional Settings and set the default system locale to Arabic or Hebrew.

Click the Currency tab, and set Currency symbol box to Euro.

Start Access and open a new database.

Create a new module.

Add the following routine to the module and run it:
```
Sub eurotest()

Dim xval as Variant
xval = FormatCurrency(123)
MsgBox xval

End Sub 
```
Note that the euro symbol in the message box is not displayed correctly.

Additional query words: prb

Keywords : kbdta kbBidi
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb