Suppress Zero values on the report

A

AccessHelp

Hello,

How can I suppress zero values on a report? There are five columns on my
reports. If there is a zero value in any of the columns, I would like to
show it as null in any of the columns with zero values.

Thanks.
 
F

fredg

Hello,

How can I suppress zero values on a report? There are five columns on my
reports. If there is a zero value in any of the columns, I would like to
show it as null in any of the columns with zero values.

Thanks.
Click to expand...

Set the Format Property of the control to:
#;-#;""
 
A

AccessHelp

Good morning fredg,

Thank you very much for your help. You are good. It works. Is there a
book out there that I can learn all those tricks?

Thanks again.
 
F

fredg

Good morning fredg,

Thank you very much for your help. You are good. It works. Is there a
book out there that I can learn all those tricks?

Thanks again.
Click to expand...

It's available in Access help.
Format property + Number and Currency datatype
 
Top