Append Query - Cutting off Comment length field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have a column named "Comments" in a table that I've set the field size
to max length of 255. I can type comments into that field up to 255.
However, when I append that same field and comment into a similar table it
cuts the comment off at the length of 50 characters? The new table has the
field size set to 255 also. Why does the Access append query cut off my
comments to 50 length comment when the field size is set to 255?
 
Are you sure about the target field having a length of 255? Can you open
the target table and type 255 characters into the field? If yes, then
something in the append query is truncating the data.
Perhaps you can post the SQL of the Append Query?
 
Back
Top