Suppress Zero values on the report

[Guest]

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.

 

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

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

 

[Guest]

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.

 

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

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