Memo field truncated

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
 
A

Allen Browne

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.
 

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.

Ask a Question

Similar Threads

Memo field is truncating in group heading of an Access 2007 report 3
Exporting a Report with a Memo Field to Excel 1
Exporting to excel is truncating my data 2
text box in report is truncating memo field at 255 characters 2
Memo field being truncated 6
Why is the text in my memo boxes being truncated in my reports? 4
the data just won't show! 0
How to Print a large memo field on multiple pages without losing . 1

Top