negative numbers

T

tman

I need some help making a field on a report NOT display
negative numbers I would like it to remain blank if it
sees a negative number
Thanks
 
R

Rick Brandt

tman said:
I need some help making a field on a report NOT display
negative numbers I would like it to remain blank if it
sees a negative number
Thanks
Click to expand...

The format property for numeric controls/fields has four sections separated
by semi-colons. They control respectively...

Formatting for positive numbers
Formatting for negative numbers
Formatting for zero
Formatting for Null

In your case just use "" in the second section and negative values will
display as blank.
 
Top