Report cuts off data from memo field

[Risikio]

I have a field that is set to memo. When I place this field in a report, the
report shows only part of the information in the memo field. I have set all
properties (Detail, text box, etc.) to can grow.

Any help would be appreciated.

Thanks.

 

[Rick Brandt]

I have a field that is set to memo. When I place this field in a
report, the report shows only part of the information in the memo
field. I have set all properties (Detail, text box, etc.) to can
grow.

Any help would be appreciated.

There are limitations to what you can do to a Memo field compared to a Text
field. Trying to do these things in Access 97 and older just caused an
error. In Access 2000 and newer this was "improved" so that instead of an
error the memo field is just silently truncated at 255 characters and then
that truncated value is used instead of the original memo field data. You
have done something to trigger this in either your report or in the query
used by the report.

In the query...
Cannot use DISTINCT (Unique Values)
Cannot use a format property on the memo field
Cannot use Group By on the memo field
Cannot be a UNION query (unless it uses UNION ALL)

In the report...
Cannot apply format property to the TextBox housing the memo field
Cannot use Memo field in the Sorting and Grouping dialog
Cannot have a Mask on the TextBox (though that shouldn't apply to a report)

(I probably missed a few)

 

[Risikio]

Thanks Rick. After going back and checking, I inadvertently had the field
set to group by in the query. Problem solved.