Printing memo field

  • Thread starter Thread starter Janet Russell
  • Start date Start date
J

Janet Russell

I have a report that shows all information for an
individual employee. All the fields print on the report
just fine except for the memo field. Only part of the data
in the memo field prints. It looks like only the first
255 characters print, although I haven't actually counted
them. This makes no sense to me since it is a memo field,
not limited to 255 characters. All the data appears on
the form for data entry.

I have set the Can grow property for this field on the
report to "yes", but it does not grow. It doesn't even
print enough of the data in the field to fill the area
I've allowed for the field on the report.

How can I make all the data in the memo field print on the
report?
 
You can check the replies to your posting this morning.
Copied for your benefit
====================
Check the report's record source. If you don't see more than 255 characters
in the datasheet view then you will need to change the SQL of the query.
This usually involves removing phrases like "GROUP BY" or "DISTINCT" or
"DISTINCTROW"
The other cause of this is a value in the Format property of the text box.

====================
 
Thanks for the help. I turned out that the problem was an
expression I created that combined the first name
([Fname]) and last name ([Lname]) into one calculated
field named "name". When I changed the name to "Ename",
the memo field printed just fine. This is something I
tried based on answers to other problems people posted.
I've learned a lot from reading these postings.
 
Back
Top