Print Blank instead if Zero

[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

[fredg]

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.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[Chegu Tom]

Thanks again Fred

"fredg" <fgut...@example.invalid> wrote in message
news:1rhuo4i0fywn5.id6k0l7su04z$.dlg@40tude.net...

[io9...@gmail.com]

THANK YOU! Been looking for this, worked PERFECTLY. :)

[sqlw...@gmail.com]

Thank you, Fred! Exactly what I needed!

[thebrow...@gmail.com]

Thanks so much Fred, worked perfectly!