MS Access - Avoiding Text Trancations

I have a memo field that I need to pull into a query. The text of the memo field in question, however, gets truncated once I pull it into the query. It is my understanding that truncating memo fields in queries is something standard that MS Access does. Am I correct and how do I work around that?

Any thoughts would be appreciated.

Who is Participating?
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:
Access doesn't always truncate.   Here's a good link which walks through all the reasons why a memo field gets truncated:

If you can avoid these, you will get the full field.

You can write function(s) for operations with MEMO fields.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.