wrapping text in a query field

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
 
A

adam.vogg

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.
 
F

fredg

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.
 

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

Similar Threads

Memo fields not displaying in query 4
memo field in the select query 2
Can rich text format (memo) carry over in a make table query? 1
Query field size quandry 2
Make Table Query Truncating Memo Field at 255 Characters 2
Memo fields in a query 4
Query with memo field shows only two chinese charcters when linked 3
Can't create a report from my query in Access 1

Top