How to make field in report show as currency.

[pleasehelpalot]

I have a report that's generated from quiries and forms. I've set the property to currency in the table, forms and report but it won't show as currency in the report. I want $100.00 not 100.
Any suggestions?

 

[RuralGuy]

Use the Format() function:
=Format([YourField],"Currency")

HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit

 

[pleasehelpalot]

Thanks for responding but I found what worked was to create an input mask. $AAAA.
Formatting didn't work for some reason.
As long as it works, it's ok with me.