FIELD DOES NOT SHOW

Question

I have been using the same access database for years.  I have a memo field (now called long text field) that suddenly will only show 2 lines of text and not all of the text entered when I run a query or run a report? Please help.

Judy Wuchter

Answer 1

Judy,

There is a well known issue with Memo fields being truncated at 255 characters, see: http://allenbrowne.com/ser-63.html

Is this the case, is it truncated at 255 chrs?

---

Daniel Pineault, 2010-2016 Microsoft MVP Professional Support: http://www.cardaconsultants.com MS Access Tips and Code Samples: http://www.devhut.net