Re: Sql Insert Error

Jeff,

Either
Set maxlength in the control you are using for input.
Or
Use leftStr in the beforepost of your ado component or when setting the
field value for a sql statement..

Bill
"Jeff" <jhoward@xxxxxxxxxxxx> wrote in message
news:45ae555a$1@xxxxxxxxxxxxxxxxxxxxxxxxx
I am getting the message "the field is too small to accept the amount of
data you attempted to add. Try inserting or pasting less data". I really do
not want to make my text field so large just to handle a few users incoming
data that may be to large for my description field. Is there a way around
this to force it to truncate the data?

Using ADO command component and inserting into MS Access.

Thanks!



.