Access and SQL Server data type problem

[rayc]

I have an Access ADP file that communicates with an SQL Server database. Last week we were forced to modify a table which originally had MONEY datatype, to DECIMAL(20,5) data type (we now need 5 decimal places).



Now when we run our Access applications, all our reports display this field without the Currency format. In other words, we used to have "2135,47$" showing up in the report (this is a French application so the dollar sign showed up at the end when I set the Format property of the textbox to Currency). This is how it should appear.

But when we made the change, now the report shows 2135.47122.

The report doesn't seen to respond to the Currency format property now. Is this an issue with Access and DECIMAL data types in SQL Server? Or am I forgetting something? This seems to be the same problem with forms that have this field displayed.

Any help would be greatly appreciated.
Thansk in advance

[pkstormy]

You can format it in the query as an expression with the dollar sign. Look at the format command.