>> Hide zero

J

Jonathan

Hi, I can't remember how to suppress zeros in a report. That is I want to
show 0.1 and show 1.0 and not show 0.0

Any ideas or suggestions appreciated :)

Many thanks,
Jonathan
 
D

Dirk Goldgar

Jonathan said:
Hi, I can't remember how to suppress zeros in a report. That is I want to
show 0.1 and show 1.0 and not show 0.0

Any ideas or suggestions appreciated :)
Click to expand...


The Format property of the text box allows this. You can set 4 separate
formats for different types of values: positive numbers, negative numbers,
zeros, and Null.
 
F

fredg

Hi, I can't remember how to suppress zeros in a report. That is I want to
show 0.1 and show 1.0 and not show 0.0

Any ideas or suggestions appreciated :)

Many thanks,
Jonathan
Click to expand...

Set the Format property of the control to:
#.##;-#.##;""
 
Top