I am trying to use the Can Shrink feature in Access - I found an
earlier post that walked me through the If statement to use to clear
out the label that corresponds with a null field but now just the
label and the field are blank, the report is not moving up. I was
wondering if anyone could assist with this issue?
Melanie
Menelomie wrote:
>I am trying to use the Can Shrink feature in Access - I found an
>earlier post that walked me through the If statement to use to clear
>out the label that corresponds with a null field but now just the
>label and the field are blank, the report is not moving up. I was
>wondering if anyone could assist with this issue?
You can make the text box invisible (which also makes its
attached label invisible).
Me.thetextbox.Visible = Not IsNull(Me.thetextbox)
This way the label will not prevent the section from
shrinking.
If the label is not attached to the text box, then make both
the text box and the label invisible:
Me.thetextbox.Visible = Not IsNull(Me.thetextbox)
Me.thelabel.Visible = Not IsNull(Me.thetextbox)
Make sure the section's CanShrink property is also set to
Yes
--
Marsh