Text control won't expand

[Linda]

I have text controls that are word wrapped and a 250 size. Can enter the
text, and it does wrap, but the size of the control won't expand to see all
the text that is entered. Some people will enter 3 words, some a paragraph,
so the text control needs to expand the cell instead of having to lock the
cell size to the largest needed. Any ideas how to overcome?

 

[Simon Lloyd]

Why not add scroll bars in the textbox properties rather than resizin
the box and whatever else its in on the fly


I have text controls that are word wrapped and a 250 size. Can enter th
text, and it does wrap, but the size of the control won't expand to se
al
the text that is entered. Some people will enter 3 words, some
paragraph
so the text control needs to expand the cell instead of having to loc
th
cell size to the largest needed. Any ideas how to overcome?


--
Simon Lloyd

Regards
Simon Lloyd
'Excel Chat' (http://www.thecodecage.com/forumz/chat.php)

 

[ozgrid.com]

Set the AutoSize property to True or add a vertical scrollbar.