update query error with memo field

[kkson]

I am trying to run an update query and i get the following error: The parameter values are too large. The total length of all the values entered for the parameters cannot exceed 1,024 characters.

The field is a memo field and it is just updating the other related records memo field also.

if i copy and paste from the form to the table itself there is no error. here is the sql:
UPDATE tblLCHDR SET tblLCHDR.ShippingMarks = [forms]![frmlc]![shippingmarks]
WHERE (((tblLCHDR.LCNO)=[forms]![frmlc]![lcno]));

also the field only has 467 characters in it. I found that by making a temp field on the form and made it = len([shippingmarks])

thanks

 

[gwinn7]

What happens if you not include the form reference and do a straight update from table field to table field?

What I am getting at is substitute your references of your form with the actual source of the data. Generally, you should do that in most cases anyway and avoid referencing your forms directly when doing SQL operations.

Gary
gwinn7