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
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
base recommends upgrading to Service Pack 3 which I've done but still only
get 255 characters.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.