Form - how to get text to wrap

  • Thread starter Thread starter Rose B
  • Start date Start date
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?
 
You have to format the cell to wrap text. There will be a block to check in
the same location as the merge cell.
 
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!
 
Back
Top