Microsoft KB Archive/287466

= ACC2002: Euro Currency Symbol Does Not Appear in Tables Exported to XML =

Article ID: 287466

Article Last Modified on 11/6/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q287466



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

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SYMPTOMS
When you export a table that includes a field with the currency data type formatted in the euro currency style to an Extensible Markup Language (XML) document, the euro currency symbol is not displayed when the exported data is viewed in a browser.



RESOLUTION
To resolve this issue, use a query to concatenate the euro currency symbol to the data values from the table. If you are using a Microsoft Access project (.adp), you can use a view.

Create a Query Using an Access Database

 * 1) In the Database window, click Queries under Objects, and then double-click Create query in Design view.
 * 2) In the Show Table dialog box, select the table that contains the field formatted as Euro, click Add, and then click Close.
 * 3) In the Field list, select the fields that you want to export, including the field formatted as Euro.
 * 4) Click the field formatted as Euro, delete the text, and then type ECost: Chr(128) & [FieldName], where [FieldName] is the name of your field formatted as Euro.
 * 5) On the File menu, click Save As. Type qryEuroCost when prompted, and then click OK.
 * 6) On the File menu, click Export. Click XML Documents in the Save as type list, and then click Export.

This automatically assigns the file name to the name of the object being exported.
 * 1) In the Export XML dialog box, click to select the Presentation of your data (XSL) check box, and then click OK.
 * 2) Start your browser and open qryEuroCost.htm.

Notice that the currency values are formatted with the euro currency symbol.

Create a View Using an Access Project

 * 1) In the Project window, click Queries under Objects, and then double-click Create view in designer.
 * 2) In the Show Table dialog box, select the table that contains the field formatted as Euro, click Add, and then click Close.
 * 3) In the Field list, select the fields that you want to export, including the field formatted as Euro.
 * 4) In the design grid, select the name of your field formatted as Euro under Column, delete the text, and then type Char(128) + Cast([FieldName] as VarChar(15)), where [FieldName] is the name of your field formatted as Euro.
 * 5) In the same row, type ECost under Alias.
 * 6) On the File menu, click Save As. Type vw_EuroCost when prompted, and then click OK.
 * 7) On the File menu, click Export. Click XML Documents in the Save as type list, and then click Export.

This automatically assigns the file name to the name of the object being exported.
 * 1) In the Export XML dialog box, click to select the Presentation of your data (XSL) check box, and then click OK.
 * 2) Start your browser and open vw_EuroCost.htm.

Notice that the currency values are formatted with the euro currency symbol.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce the Problem
 Start Access, click Blank Database on the task pane, type the file name EuroTest, and then click Create. In the Database window, double-click Create table in Design view.  Create the following table:   Table: EuroCost Field Name: ItemID Data Type: Autonumber

Field Name: ItemName Data Type: Text

Field Name: ItemCost Data Type: Currency Format:    Euro  On the File menu, click Save As. Type EuroCost when prompted for the table name. When prompted for a primary key, click Yes. Open the table EuroCost, type three rows of data of your choice, and then close the table.</li> On the File menu, click Export. Click XML Documents in the Save as type list, and then click Export.</li> In the Export XML dialog box, click to select the Presentation of your data (XSL) check box, and then click OK.</li> Start your browser and open EuroCost.htm. Notice that the cost values are not formatted with the euro currency symbol as expected.</li></ol>

Additional query words: pra

Keywords: kbbug kbpending KB287466

-

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

© Microsoft Corporation. All rights reserved.