I have a very strange problem with a multi step error.

I can overwrite fields in my MySQL database as long as they are shorter than the values already entered!

If they are longer I get a multi step error.

I have checked all the data types etc. etc. and their all OK.

I am overwriting the data not updating i.e.

sql = "SELECT * from blah where blah=blah"

connection here

rs.AddNew
rs("Regiment") = string
Save Recordset

If the string is shorter than what is already in the field it works fine it is only when the string i am trying to input is longer i get a multi step error.

Could it be to do with mysql's attempt at eliminating whitespace?