MS Access - Avoiding Text Trancations

Posted on 2012-09-18
Last Modified: 2012-09-18
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.

Question by:maroulator
    LVL 56

    Accepted Solution

    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.

    LVL 39

    Expert Comment

    You can write function(s) for operations with MEMO fields.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now