dynamic label formatting??

  • Thread starter Thread starter bensonwd
  • Start date Start date
B

bensonwd

I'm trying to make the height of a Label equal the height of a Text
Box that can grow to the size of its corresponding data field.

Does anyone know if this is possible?

The reason I'm doing this is to make this new Access report have the
same look and feel of the current print-out version that doesn't exist
electronically.
 
bensonwd said:
I'm trying to make the height of a Label equal the height of a Text
Box that can grow to the size of its corresponding data field.

Does anyone know if this is possible?

The reason I'm doing this is to make this new Access report have the
same look and feel of the current print-out version that doesn't exist
electronically.
Click to expand...


It's not the label you need to change, it's the border.
Unfortunately, there is no way to determine the can grow
height at the time you need to adjust the size of another
control.

Instead, use the Line method in the section's Print event to
draw the border lines. Then code will oribably be something
like:

Me.Line (lbl.Left, lbl.Top)-Step(lbl.Width, txt.Height), , B

where lbl is the name of the label control and txt is the
name of the text box.
 
Back
Top