Ensuring all text boxes grow together

[Guest]

Hi.

I have a report with a row of text boxes all the same height in a particular
report section which is set to grow. All text boxes are set to grow but it's
only the last one, containing comments, that would actually have enough
content to make it grow.

When this last box does grow for a particular record, all the others remain
at the same height and this creates a sort of toothy gap. Is there a way that
I can ensure all text boxes grow to match the height of the last one?

Thanks, JohnB

 

[Marshall Barton]

I have a report with a row of text boxes all the same height in a particular
report section which is set to grow. All text boxes are set to grow but it's
only the last one, containing comments, that would actually have enough
content to make it grow.

When this last box does grow for a particular record, all the others remain
at the same height and this creates a sort of toothy gap. Is there a way that
I can ensure all text boxes grow to match the height of the last one?

No there isn't.

OTOH, you don't care if the other text boxes grow, you only
want their borders to line up. This can be done by setting
the text boxes BorderStyle to Transparent and then using the
detail section's Print event to draw the lines using the
report's Line method. While there are a few tricky
situations to code through, it is not outrageously
complicated unless you are not fairly competent with VBA.
You may prefer to use Stephen Lebans PrintLines function at
www.lebans.com

 

[Guest]

Hi again Marsh.

Thanks for that. I'll have a look at both methods.

Cheers, JohnB