memo feild truncated

  • Thread starter Thread starter Taher
  • Start date Start date
T

Taher

I have a memo feild which comes from a table and i have
made it to print at the page footer. My memo feild is
quite large and has a lot of text. But for some reason in
the report its showing only some part of the entered text.

I would appreciate someone's help on this issue.

Thank you.
 
You should check the length of the field in the design.
You might need to elongate it further.
 
If your memo field is formatted as upper-case the report
will only display 255 characters. Also, make sure that the
control is set to "Yes" in the "Can Grow" option.
 
Suggestions:

1. You cannot use Can Grow in the Report Footer section, so the text box and
the section will have to be tall enough to cope with the largest amount of
text you could ever need.

2. Make sure that this text box on the report has nothing in its Format
property.

3. If the report is based on a query, open the query directly, and see if
the query is returning the full memo field. It will not if it performs
aggregation (e.g. DISTINCT or GROUP BY memo).
 
Back
Top