Report - Hidding Controls on a condition

C

ChrisP

I created a report and it works perfectly. I want to set
a condition for 2 controls, a label and a textbox, that
will hide them if there value is 0 or null.

I have no idea how to accomplish this.
 
J

Jeff Boyce

Chris

Is the label "attached" to the control? Consider setting the CanGrow and
CanShrink properties of the textbox control to "Yes". Then, if there's no
data, the control won't show.

If your underlying data could be a value of "0", this won't work. But you
could use a query to set it to Null if it is "0", so you could still use the
CanGrow/CanShrink.
 
Top