Can Grow property for Text box in Report

[Wild Horse]

I have problem to make all textbox in report can grow if one of them has the text longer then others.

Anyone has an idea ?

Thanks
AH

 

[maxmangion]

select all of your textboxes, goto properties and set the Can Grow property to Yes

 

[Wild Horse]

It is not worked as what I want. only the textbox that contain longer text will be grow, but the rest are not. with this setting, when we set the border of all text to solid line, the report will be so ugly.
other ideas?
thanks
AH

 

[WayneRyan]

AH,

A little complex, but it works:

http://www.access-programmers.co.uk/forums/showthread.php?t=40186&highlight=growbox

Wayne