I created a memo field in a table to hold lengthy explanations however when I
preview this field in a report it's cutting off the majority of the text.
Usually one or two lines are printing. I've expanded the field to accomodate
more characters but that isn't working either.

Do you have any suggestions on how to force the field to display all the text?

I appreciate any help you can provide.

Memos on reports can be problematic at times. Most likely it is
truncating down to 255 characters?

Is the report's recordsource a query? Some queries will truncate memo
fields automatically, such as Crosstabs, Summary, Union, and SELECT
DISTINCT.


This site has some more insight:

http://allenbrowne.com/ser-63.html

"PF509" wrote:

> I created a memo field in a table to hold lengthy explanations however when I
> preview this field in a report it's cutting off the majority of the text.
> Usually one or two lines are printing. I've expanded the field to accomodate
> more characters but that isn't working either.
>
> Do you have any suggestions on how to force the field to display all the text?
>
> I appreciate any help you can provide.

Have you examined the "CanGrow" property of the report (text box) field? If
this is set to "No" (the default), then you will get truncation based on the
size you choose for the field.