update statement truncating memo field data

[Martin Payne]

Hi all,

I have a form with an unbound textbox and, when I click the OK button,
I create a connection and execute an update, inserting the contents of
the textbox into a memo field. My problem is that only 255 characters
end up being inserted. I have quadrupple checked and the field is
definitely a memo field and there does not seem to be any property on
the textbox that could be causing the problem. So, that only leaves
the connection and the execution of the update statement.

Does anyone know of any limitation in the ADODB.connection object that
would cause this problem and, hopefully, what the workaround is?

Thanks
Martin

 

[John Vinson]

Hi all,

I have a form with an unbound textbox and, when I click the OK button,
I create a connection and execute an update, inserting the contents of
the textbox into a memo field. My problem is that only 255 characters
end up being inserted. I have quadrupple checked and the field is
definitely a memo field and there does not seem to be any property on
the textbox that could be causing the problem. So, that only leaves
the connection and the execution of the update statement.

Does anyone know of any limitation in the ADODB.connection object that
would cause this problem and, hopefully, what the workaround is?

Thanks
Martin

Be sure that you don't have any Format property on the textbox or the
field, and that you're not sorting by the field.

Perhapse you could post your actual code and/or the SQL of the query
into which you're inserting (if it is a query).

John W. Vinson[MVP]