Having a row adjust in height to accommodate text entry

[John]

In a form that I'm developing I have 4 columns and 5 rows. I would like for
the row height of all rows to automatically adjust to accommodate the text
entry in any given colum/cell. Is there an easy way to accomplish this? Will
it make a difference whether the worksheet is protected or not?

 

[fredg]

In a form that I'm developing I have 4 columns and 5 rows. I would like for
the row height of all rows to automatically adjust to accommodate the text
entry in any given colum/cell. Is there an easy way to accomplish this? Will
it make a difference whether the worksheet is protected or not?

Column/Cell?
Worksheet?
Sounds like an Excel question.
You have posted this question to the wrong newsgroup.
The access in this groups title refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for the Excel program you are
using.
I would suggest you include your Windows and Office version number in
your message. It might make a difference.

 

[golfinray]

Set the cangrow property to Yes

 

[Douglas J. Steele]

CanGrow doesn't work like that on forms.

Both the CanGrow and CanShrink properties only apply for forms and reports
that are printed (or print-previewed).