Shrinkable Label

[Terry]

I have a report (Purchase Order) that has multiple items - 2 lines per item.
The 2nd line is a notes feild for the second item, and is labeled "Item Note
1", "Item Note 2", Etc. I have the text box attached to that label set to
"can shrink - yes" so that it disappears if empty. The Label has no such
"can shrink" setting, so it even if the text box is empty and shrinks, the
label remains. Is there a way to remove the label also if the attached text
box shrinks so that the whole line condenses?

Thank you,

Terry

 

[Marshall Barton]

I have a report (Purchase Order) that has multiple items - 2 lines per item.
The 2nd line is a notes feild for the second item, and is labeled "Item Note
1", "Item Note 2", Etc. I have the text box attached to that label set to
"can shrink - yes" so that it disappears if empty. The Label has no such
"can shrink" setting, so it even if the text box is empty and shrinks, the
label remains. Is there a way to remove the label also if the attached text
box shrinks so that the whole line condenses?

Add a line of code to the memo field section's Format event.

Me.memotextbox.Visible = Not IsNull(Me.memotextbox)

 

[Terry]

Thank you,
That works to hide the box, but I want it to actually shirnk so that the
entire detail section condenses up for all the records that are empty
Any other ideas?
Terry

 

[Marshall Barton]

Then you also need to set both the text box and its
section's CanShrink property to Yes.