Can Shrink

H

Howard

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
 
M

Marshall Barton

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)
 
Top