Can Shrink

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a text box on a report that shows the result of a formula. If the formula result is zero, we don't want the text box to show when the report is printed, and we want the next line to move up (can shrink). Is there any way to do this

Thanks
Howard
 
Howard said:
We have a text box on a report that shows the result of a formula. If the formula result is zero, we don't want the text box to show when the report is printed, and we want the next line to move up (can shrink). Is there any way to do this?
Click to expand...


Two things to try. One is to set the text box's expression
to:
=IIf(<formula> = 0, Null, <formula>)

The other is to use code in the text box section's Format
event:
Me.thetextbox.Visible = (Me.thetextbox <> 0)
 
Back
Top