Append Query - Cutting off Comment length field

D

dallin

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?
 
J

John Spencer

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Converting URLs in comments to Markdown-formatted links 2
Query field size quandry 2
MS Access 2007 Cutting Text from Field 0
Append to SQL Server 3
SQL Strings Truncating at 255 Characters ? Why? 1
disctinct query memo field 3
Query / Count Length Of Field 3

Top