INSERT INTO query: Data chopped off at 255 char

[LEXCERM]

Hi all,

I'm using an INSERT INTO query (in a standard VBA module) and one of the fields in the underlying table is set to MEMO.

Query runs okay, but only the first 255 characters are inserted. When I Debug.Print to the Immediate Window, all 423 characters are displayed correctly.

Please advise.

Thanks in advance.

 

[Ranman256]

Thank Microsoft for that. Why would we want ALL our data Microsoft?
It CAN be done tho, but queries wont do it.
Try transferspreadsheet
or
transferText

 

[LEXCERM]

Thanks for the reply Ranman256.

The string is being created from different fields on a form.
Will your method still work in this case?

Thanks.

 

[Ranman256]

then instead of doing an append query,
just connect the form to the table, and ENTER the data directly.