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

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
 
D

Duane Hookom

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

fredg

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
 
Top