suppress $0.00 in calculated field

D

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
 
F

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
 
M

Marshall Barton

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

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.
 
Top