Microsoft KB Archive/282359

= ACC2002: Stored Procedure Output Loses Euro Currency Symbol Format =

Article ID: 282359

Article Last Modified on 11/6/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q282359



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

This article applies only to a Microsoft Access project (.adp).



SYMPTOMS
When you use a stored procedure to query a table with a field formatted as Euro, the format of the output is unexpectedly converted to Currency.



CAUSE
This behavior occurs because the Visual Design Tools in Microsoft Access do not support property inheritance for stored procedures.



RESOLUTION
To display the euro currency symbol correctly, create a view or an In-Line Function instead of a stored procedure.



Steps to Reproduce the Behavior

 * 1) Open the sample project NorthwindCS.adp.
 * 2) Open the Orders table in Design view.
 * 3) Change the Format setting of the Freight field from Currency to Euro.
 * 4) Close and save the table.
 * 5) On the Insert menu, click Query. Select Design Stored Procedure, and then click OK.
 * 6) Add the Orders table and click Close in the Add Table dialog box.
 * 7) Select the Freight field and save the stored procedure.
 * 8) Open the stored procedure in Datasheet view.

Note that the Freight column is displayed in the Currency format.

