Print Blank instead if Zero

  • Thread starter Thread starter Chegu Tom
  • Start date Start date
C

Chegu Tom

I have many numeric fields that should show blank of the value is Zero.

Is there a way to set that for the whole report (all zeros fields show as
blank)

I could do iif( statement) for each one but would rather have a global fix
 
I have many numeric fields that should show blank of the value is Zero.

Is there a way to set that for the whole report (all zeros fields show as
blank)

I could do iif( statement) for each one but would rather have a global fix
Click to expand...

In Report Design View, select each of the fields you wish to display
blank instead of 0 (Hold down the Shift key while you click on each
control).

Display the property sheet.
Set the Format property to:
#;-#;""

Save the change.

Zero's will be blank.

In Access help, see
Format property + Number and Currency Datatype
to learn why this works.
 
Thanks again Fred


fredg said:
In Report Design View, select each of the fields you wish to display
blank instead of 0 (Hold down the Shift key while you click on each
control).

Display the property sheet.
Set the Format property to:
#;-#;""

Save the change.

Zero's will be blank.

In Access help, see
Format property + Number and Currency Datatype
to learn why this works.
Click to expand...
 
Back
Top