Re: Print Blank instead if Zero

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Mon, 20 Oct 2008 13:12:35 -0500, Chegu Tom wrote:

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

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

Quantcast