blanks instead of zeros

[Bill]

How do I get a field that has zeros to display a blank?

 

[Shawn Pollack]

Try using a custom text field instead and a custom formula. For instance, if
you want the Duration to show a blank if it is zero, display Text1 instead
and put a formula in the custom field. For instance:

IIf([Duration]=0,"",([Duration]/480))

The Customzed Fields can be accessed from Tools:Customize:Fields... Custom
Attrributes -> Formula...

 

[Bill]

thanks