Avoid printing the number 0

[twallstr]

I have a problem with blank fields being printed in a report as the number 0. This is true only for numbers, not text or dates.
How would I do to have those fields printed blank and not with a 0?

Thanks!
twallstr

 

[Smart]

This probably isn't ideal but you could;

Select the field that contains 0 on the menu bar click on format then conditional formatting
Under condition1 select field value is then in the next dropdown box select equal to in the next field type 0
Then click on the A dropdown list and select the colour white.

If the value in the field is equal to 0 then the colour of the 0 will be changed to white thus making the 0 invisible

 

[twallstr]

Smart!
Works great. Simple solution.

Great! Thanks!

twallstr