0 value is blank

J

jana

I would like to print a report where if the value of the
field is 0 is prints out as a blank field.

Can anyone help me do that?

Jana
 
M

Marshall Barton

jana said:
I would like to print a report where if the value of the
field is 0 is prints out as a blank field.
Click to expand...


Set the text box's Format property to a custom format. If
your numbers are integers, you could use something like
#,##0;;"";""

See Format Property in Help for details about formatting
options.
 
Top