Suppress Zero

N

NevilleT

Probably a very simple answer to this but I can't find it. How do I suppress
zero (display as a blank) on a report.
 
F

fredg

Probably a very simple answer to this but I can't find it. How do I suppress
zero (display as a blank) on a report.
Click to expand...

Set the Format property of the control to:
#;-#;

Look up the Format property + Number and Currency datatype in Access
help.
 
N

NevilleT

Thanks Fred. That did the trick.

fredg said:
Set the Format property of the control to:
#;-#;

Look up the Format property + Number and Currency datatype in Access
help.
Click to expand...
 
Top