Format decimal fields as money

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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

=Format([FieldName],"currency")

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