losing part of string

[clara]

Hi all,

I concact a string field in the my report detail print event, and display
the whole string in a textbox in groupfoot event. If I narrow my form
criterias to display a single group on my report, the whole string will
displayed, but if I make multiple groups to be displayed, part of the string
will miss in some groups.

Clara

 

[Allen Browne]

See:
Truncation of Memo fields
at:
http://allenbrowne.com/ser-63.html

In essence, you need to ensure Access is not performing any grouping on the
memo field.