Problem with memo field

[Guest]

I am working in access 97 and I have a text box that is bound to a memo
field. The text box is truncating the data in the memo field. how can I fix
that to make the text box show every thing in the memo field? I checked the
data in the table to make sure that it is there and It was.
thanks
Al

 

[Marshall Barton]

I am working in access 97 and I have a text box that is bound to a memo
field. The text box is truncating the data in the memo field. how can I fix
that to make the text box show every thing in the memo field? I checked the
data in the table to make sure that it is there and It was.

If the text box is really the culprit here, ir's because you
specified something in its Format property.

Since that is rather unlikely, I suspect that the truncation
is ocurring in the form's record source query where using a
memo field in a GROUP BY clause, using the DISTINCT
predicate, or ??