memo field on report

[JohnE]

I am creating reports from an A2k database. There are
tables that have memo fields. Many of these fields are
lengthy. But, when I do the report, the memo field cuts
off part way thru. The field's property setting is set
to CanGrow.
How can I make the report field show all of the memo
field contents?
Thanks to anyone who responds.
*** John

 

[Marshall Barton]

I am creating reports from an A2k database. There are
tables that have memo fields. Many of these fields are
lengthy. But, when I do the report, the memo field cuts
off part way thru. The field's property setting is set
to CanGrow.
How can I make the report field show all of the memo
field contents?

There are several things in a query that truncate memo
fields to 256 characters. DISTINCT and UNION will do that,
and so will GROUP BY memo and ORDER BY memo.

Another thing to look out for is using anything in the text
box's Format property.

 

[JohnE]

Marsh, thanks for the info. The GROUP BY was there. I
removed it and there was the whole note. I will keep
your your reply in mind in the future.
*** John

 

[JohnE]

Marsh, if your still checking, I find that I need to use
the totals line in some queries that have the memo
field. I've tried deleting the GROUP BY or changing it
to something else. Is there a "workaround" that can be
done that you are aware of?
Thanks for the help.
*** John

 

[Duane Hookom]

Try change the memo field from Group By to First.