How to get $0.00 to show in text box on report

[SAFE]

I have a report with currency fields. If no amount is present I want the field to show $0.00. Instead it just comes up blank. I've tried formating the field in the table and the text box but nothing changes.
Any answers?

 

[CosmoKramer]

Add an unbound text box to your report, set its format to Currency, and its control source to something like this:

=IIf([YourAmountField] Is Null,0,[YourAmountField])

I'm CosmoKramer, and I approve this message.

 

[SAFE]

Thanks, that worked.

 

[dhookom]

Setting the format property should work. Try:
$#,##0.00[Green];($#,##0.00)[Red];"$0.00";"$0.00"
You can remove the colors if you wish.

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