dynamic label formatting??

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.
 
M

Marshall Barton

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.


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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top