Can Shrink

[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

 

[Marshall Barton]

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?

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)

 

[Guest]

Thanks. We'll give it a try first thing in the morning

Howard