>> Hide zero

  • Thread starter Thread starter Jonathan
  • Start date Start date
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
 
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.
 
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:
#.##;-#.##;""
 
Back
Top