Memo field truncated

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My memo field is truncated in reports to 255 characters. The Knowledge base recommends upgrading to Service Pack 3 which I've done but still only get 255 characters

Any ideas
 
Couple of possibilities:

1. Is there anything in the Format property of the field in the table? Or in
the Format property of the text box on your form/report?

2. Are you grouping on the memo field, e.g. your query contains DISTINCT or
GROUP BY? If it is a GROUP BY query, try choosing First instead of Group By
in the Total row under the query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Jeremy said:
My memo field is truncated in reports to 255 characters. The Knowledge
Click to expand...
base recommends upgrading to Service Pack 3 which I've done but still only
get 255 characters.
 
Back
Top