Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    1

    Unanswered: SELECT query truncating data from memo field at 255 characters

    hi all,

    i'm attempting to run a SELECT query on a memo field, but unfortunately, my data is truncated at 255 characters. does anybody know why this is, and what i can do to fix it?

    here is the line of code. i know it works, as it works perfectly for all other fields. this is from a module within access 2002.

    ("SELECT * FROM [Imports] WHERE [F41] = " & pdqID & "")

    does anybody know anything i can do to clear this up?

    thanks!

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    hmmm.... "Imports"

    where is this data coming from?

    you are probably only getting 255 chars from the source (i seem to remember that many access import-filters drop dead at 255 chars)

    izy
    currently using SS 2008R2

Posting Permissions

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