ACC2002: Stored Procedure Output Loses Euro Currency Symbol Format (282359)


The information in this article applies to:

  • Microsoft Access 2002
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.

MORE INFORMATION

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.

REFERENCES

For more information about views and stored procedures, refer to SQL Server Books Online.
Modification Type:MajorLast Reviewed:11/6/2003
Keywords:kbnofix kbprb KB282359
©2003 Microsoft Corporation. All rights reserved.