suppress $0.00 in calculated field

[Dave]

How do you suppress or not show the $0.00 in a calculated
field in a report? I want the column to still show, but
not the $0.00.

Thanks in advance for your help

 

[Fredg]

Dave,
Set the Format property of the control to:
#;-#
12345 -12345

If you want your values to show comma separated thousands,
then use:
#,###;-#,###
12,345 -12,345

 

[Marshall Barton]

How do you suppress or not show the $0.00 in a calculated
field in a report? I want the column to still show, but
not the $0.00.

Use a custom format that displays nothing instead of zeros.
Possibly, one like:

$#,##0.00;($#,##0.00);""

See Format Property in Help for details of all the options
you can use in custom formats.