wrapping text in a query field

  • Thread starter Thread starter MaryLou
  • Start date Start date
M

MaryLou

I set up the field in table to memo and tried entering a lot of information
but when I open the report that field does not expand to show all of the
entries. Can this be done in query and reports both.

Thanking you in advance.
Mary Lou
 
I set up the field in table to memo and tried entering a lot of information
but when I open the report that field does not expand to show all of the
entries. Can this be done in query and reports both.

Thanking you in advance.
Mary Lou
Click to expand...



Go to the properties of the text box on the field that is displaying
the Memo data, and under the format tab, set Can Grow? to Yes. That
will allow it to grow vertically.
 
I am using Access 2000 and I don't see where to make the change to allow to
grow
Click to expand...

Open the report in Design View.
Select the memo field in question.
On the memo field's property sheet's Format tab you'll find the
CanGrow property. Set it to Yes.
Also set the Detail section's CanGrow property to Yes (assuming the
memo field is placed in the Detail section).
Make sure the Memo field's Format property is blank.
 
Back
Top