• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 395
  • Last Modified:

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.

-Maroulator
0
maroulator
Asked:
maroulator
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Access doesn't always truncate.   Here's a good link which walks through all the reasons why a memo field gets truncated:

http://allenbrowne.com/ser-63.html

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

Jim.
0
 
als315Commented:
You can write function(s) for operations with MEMO fields.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now