How do I make a text field word wrap in a query display?



I need to have a long text field perform wordwrap instead of trailing off the
right edge of the screen. I can use the horizontal scroll bar, but I prefer
to be able to see the entire field at a glance. Increasing the heigth of the
row a record is displayed in doesn't solve the problem. thanks in advance.

Allen Browne

The datasheet view of a query cannot have line heights that vary with each

Instead, create a report, and set the CanGrow height of the text box to Yes.
Mar 19, 2015
Reaction score
Thanks for the advise, it works...however, i tried adding another paragraph in a text box but its line height extends up to 3 lines only when i set the textbox' CanGrow properties to "Yes". What will i do then to appear in my report the whole text in full.

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