By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,488 Members | 2,552 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,488 IT Pros & Developers. It's quick & easy.

Can Shrink Option

P: n/a
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
Jan 4 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Jan 8 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.