ACC2002: Euro Currency Symbol Does Not Appear in Tables Exported to XML (287466)

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

In the Database window, click Queries under Objects, and then double-click Create query in Design view.
In the Show Table dialog box, select the table that contains the field formatted as Euro, click Add, and then click Close.
In the Field list, select the fields that you want to export, including the field formatted as Euro.
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.
On the File menu, click Save As. Type qryEuroCost when prompted, and then click OK.
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.
In the Export XML dialog box, click to select the Presentation of your data (XSL) check box, and then click OK.
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

In the Project window, click Queries under Objects, and then double-click Create view in designer.
In the Show Table dialog box, select the table that contains the field formatted as Euro, click Add, and then click Close.
In the Field list, select the fields that you want to export, including the field formatted as Euro.
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.
In the same row, type ECost under Alias.
On the File menu, click Save As. Type vw_EuroCost when prompted, and then click OK.
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.
In the Export XML dialog box, click to select the Presentation of your data (XSL) check box, and then click OK.
Start your browser and open vw_EuroCost.htm.

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

MORE INFORMATION

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.
On the File menu, click Export. Click XML Documents in the Save as type list, and then click Export.
In the Export XML dialog box, click to select the Presentation of your data (XSL) check box, and then click OK.
Start your browser and open EuroCost.htm. Notice that the cost values are not formatted with the euro currency symbol as expected.