Having a row adjust in height to accommodate text entry

  • Thread starter Thread starter John
  • Start date Start date
J

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?
 
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?
Click to expand...

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.
 
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).
 
Back
Top