Can grow

[Guest]

I think I'm going to be embarrassed by asking this question cos the answer is
probably staring me in the face.

Form with text box. Text box has record source from a query. Query field is
result of expression concatenating two fields from a table.

Text box property Can Grow is set to yes .... but ....it doesn't grow!!

In fact any text box I put on a form doesn't appear to grow when the
property is correctly set ..... but they do if I put them on a report!

Obviously there is something I'm doing wrong and I need someone to tell me
what it might be (without making me look too much of a fool!)

Regards

Michael Bond

 

[Al Camp]

The Grow and Shrink on a form only applies to the "printing" of that form.
Select PrintPreview from your form, and you'll see the field Grow/Shrink
according to the data. But in Form View, the Grow/Shrink doesn't apply.

You could use the OnCurrent event of your form to determine the Length of
your text, and adjust the Height accordingly.
or....
Since large text fields take up so much space on a report, I usually keep
them small, showing the first few words of a long string for user reference,
but allow the user to Zoom in for reading and editing...via double click on
that field, or... OnEnter for that field could cause an automatic Zoom, or
etc... solutions to suit.

 

[Guest]

Al

thanks, very useful tips, and I didn't know about the "grow" "shrink" only
applying to "print preview". I'll be able, however, to make use of one of
your suggested alternatives.

Thanks again

Michael Bond