Results 1 to 2 of 2
  1. #1
    Huddle is offline Competent Performer
    Windows XP Access 2010 64bit
    Join Date
    Jun 2010
    Posts
    318

    Query is Truncating Memo Field


    The query I am running is truncating the memo field at 255 characters. This is a regular query not a union. Is there a cause for this?

  2. #2
    Huddle is offline Competent Performer
    Windows XP Access 2010 64bit
    Join Date
    Jun 2010
    Posts
    318
    Found the solution on this web page http://allenbrowne.com/ser-63.html

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Change Text field to Memo Field in a Query
    By Yarbz in forum Queries
    Replies: 5
    Last Post: 06-28-2012, 05:24 PM
  2. Replies: 5
    Last Post: 06-19-2012, 10:46 AM
  3. Union query truncating a memo field
    By jpkeller55 in forum Queries
    Replies: 7
    Last Post: 05-27-2011, 02:17 PM
  4. Query Memo Field
    By janelgirl in forum Queries
    Replies: 7
    Last Post: 04-19-2011, 09:01 AM
  5. HELP!!! - Importing table decimal field truncating
    By Valeda in forum Import/Export Data
    Replies: 0
    Last Post: 12-05-2006, 04:06 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums