memo field on report

  • Thread starter Thread starter JohnE
  • Start date Start date
J

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
 
JohnE said:
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?
Click to expand...


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.
 
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
 
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
 
Back
Top