Form - how to get text to wrap

R

Rose B

I have a form with a text field, which is defined to wrap text, source a cell
in a sheet. Whatever gets typed into the form, or whatever is currently held
in the underlying cell shows in the form as a single long line. What needs to
be set so that this wraps round in the form?
 
S

Steve Willis

You have to format the cell to wrap text. There will be a block to check in
the same location as the merge cell.
 
R

Rose B

The underlying cell is also set to wrap text (and does) - but the form still
shows the text in a long line.


What I have now found - after more searching - is that there is a proprty on
the form definition of 'Multiline', which I had not spotted before. Set this
to True and all is well, (even with the underlying cell not set to word wrap).

Thanks for your input though - it got me searching around again!
 

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.

Ask a Question

Top