Format a field to Currency in Report

[firsttube]

Is there a way to format a field on a Report so it appears as: "$200,000.00" ?

I have a report that looks at a query. The fields are numeric, containing values like: 200000, but I want it to look like $200,000.00 on the report. How can this be done. There doesn't seem to be an option to set it to Currency.

thanks

ft

 

[batteam]

Try something like this from the Access Help file example:


CCur Function Example
This example uses the CCur function to convert an expression to a Currency.

Dim MyDouble, MyCurr
MyDouble = 543.214588 ' MyDouble is a Double.
MyCurr = CCur(MyDouble * 2) ' Convert result of MyDouble * 2
' (1086.429176) to a
' Currency (1086.4292).

Otherwise look futher in Help under 'Format'. Good Luck

 

[Zonie32]

If you go into the query design grid, just right click on the field, go into properties and set the format to currency.

 

[dhookom]

Don't use code and don't set any formatting in the query. You should only have to set the format property of your text box in the report to "Currency".

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[liriom]

I don't get the currncy option in tformat property

 

[liriom]

I don't get the currency option in tformat property

 

[dhookom]

If you view the datasheet view of the report's record source, is the field left or right-aligned?

Can you provide the SQL view of the report's record source?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]