Adjustable Text Box???

[COB]

Does anybody know if there is a way to adjust the height of text box on a form depending on how much text there displayed? Or another way of displaying data which is stored in a memo format??
Thank you all in advance.
COB

 

[VOLLEGAAS]

Use CanGrow

 

[COB]

Sorry but that doesn't seem to work, I've set the cangrow and canshrink properties of the text box to "YES" and when the data appears, the text box remains the same size as I created it. Do I have to do something else to trigger it???
Thanks
COB

 

[Pat Hartman]

The canGrow/CanShrink properties for form controls are used only for printing the form.

You might be able to do it with VBA. You'd need to open the form in design view since the hight property is not available in form view. You would also have to figure out the code for shifting all the controls around the one you are trying to expand. I wouldn't even waste the time to try. Find a size for the box where most of the contents will show for most of the records. Then the box will have to scroll for the others.