How to show blank if the number field is zero on report

  • Thread starter Thread starter Jean
  • Start date Start date
J

Jean

Hi,

I have a report shows some number fields. But instead of show zeros, how do
I setup an expression on the field to display or be visible only when the
number is <> 0.

Thanks

Jean
 
You can set the Format property to not show 0. Check Access Help for Format
Property Numerical.
 
Hi,

I have a report shows some number fields. But instead of show zeros, how do
I setup an expression on the field to display or be visible only when the
number is <> 0.

Thanks

Jean
Click to expand...

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

See Access Help
Format Property + Number and Currency Datatypes
 
Back
Top