Shrinkable Label

  • Thread starter Thread starter Terry
  • Start date Start date
T

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
 
Terry said:
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?
Click to expand...


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

Me.memotextbox.Visible = Not IsNull(Me.memotextbox)
 
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
 
Then you also need to set both the text box and its
section's CanShrink property to Yes.
 
Back
Top