Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003

    Unanswered: 255 Character Limit Problem

    I imported data from a .txt file with fields that contained more than 255 characters. To enable the full string to import, I changed the Data Type to Memo. When I look at the data in the table, the data in the field shows more than 255 characters. When I query the data and want to display the data (complete string) in the field, it cuts it off at 255 characters. I added a field in the query to determine the length of the field. It shows field lengths of > 255, but the data is cut off at 255. How do I get the complete string to show up in the query results?

  2. #2
    Join Date
    Aug 2002
    Northampton, England
    There is an article on the Microsoft Knowledge base web site that may provide an answer.;en-us;170218


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts