Do you mean to adjust the width? Not that I know of. Would have to build
code to handle that. You can set cell Format/Alignment property to wrap text
and the row height will expand to acommodate the wrapped text.
I thought Donna meant to have this adjustment occur without any action by
user. Of course you can select the columns and use Format settings manually,
to automate would require VBA or macro.
Yes, I meant to have it do it automatically without the user having to know
how to do anything. In Word, the field grows as the entries get larger.
Thanks for your ideas about a macro or VBA.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.