Print Blank instead if Zero

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
 
F

fredg

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

Chegu Tom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top