Append Query - Cutting off Comment length field

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

Query field size quandry 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
update query - memo field 5
Append to SQL Server 3
mktbl query question 4
Append query from form input - Access 2000 1
Defining Text field sizes in destination Make-Table Query 3
disctinct query memo field 3

Top