Resizing textboxes on the fly

[accessNEWB]

I have created a report that takes data from a table and plugs them into textboxes in the form. However, some boxes may contain data that requires more than one line. Setting autoresize/can shrink/can grow is fine, but I want the rest of the text boxes to also grow and shrink in height to the tallest textbox. It looks like this

[text1][text2][text3][text4]...

all on one line, that's all the report contains (its basically a list). So if text4 becomes 4 times taller, then I want the other boxes to grow 4 times taller as well.

Thanks

 

[pgk]

Hi,
You could use the left,top,width and height properties to control a control's positioning as well as size. You could probably write some code in the OnOpen event of the report concerned. But the fact is that you will have to do a lot of checking to ensure that after the resizing the controls don't exceed the report margins and so on.

Hope this helps.
With regards,
PGK