Labels and next box's that grow

[kentwoodjean]

I have what may seem like a silly question but could sure use an answer. In some of my databases, many of the reports look like a table and as such, I really like to use the Line/Border tool. Because a text box can grow, that outlined box is oten larger than the label box that is outlined. Is there anyway that the label box can grow based on the size of its corresponding text box? That way it would look like a true table without gaps on the label side.

Hope this makes sense.

 

[formerTexan]

Hmmm, might make more sense in the Report forum :>), but I'll bite.

On the report section's Format event try the following (change your control names to suit):

Me.Label0.width = Me.Text0.width

Cheers,
Bill