Format decimal fields as money

[Guest]

Hello, I have an Access 97 application that uses SQL Server 2000 as the back-end. For a one report I'm getting a decimal field back from SQL Server but want to display it on the report as currency. How is this done? I've tried setting the format type to currency but it doesn't work

Thank

Don

 

[fredg]

Hello, I have an Access 97 application that uses SQL Server 2000 as
the back-end. For a one report I'm getting a decimal field back
from SQL Server but want to display it on the report as currency.
How is this done? I've tried setting the format type to currency
but it doesn't work.

Thanks

Don

Use an unbound control. Set it's control source to:

=Format([FieldName],"currency")

or.. =Format([FieldName],"$ #,##0.00")