ADO. Why will the .Update not stop invalid entry

[Steve Thomas]

I have an ADO control on my form bound to a field that allows 9 characters. After a user enters data in the box, I run the following code

Form.ADODC1.Recordset.update


Even though the user entered 10 digits, the update seemed to work. However, when I try and move to the next record, I get an error (Operation failed). It seems useless to run the .update if it is not really updating the record??????

If I place the following code in the same box

Form.ADODC1.Recordset.update
Form.ADODC1.Recordset.movenext

Then it errors.

I can issue a movenext and then a moveprevious but I was wondering if there is a better way??????

[Clunietp]

the ADO data control still has its quirks....what happens when you only put 9 characters into that field?

[Steve Thomas]

If I put 9 characters it seems to update it. I am having similiar problems with other issue related to this same issue. If I use the MoveNext and then MovePrevious, it works but I don't like the way it looks to the user.

[gilly]

would you be from donegal steve thomas??????????????????????

[Steve Thomas]

No. Sorry.

[Clunietp]

I suppose just put the maxlength of the textbox to 9, but that doesn't solve the ADO problem for you....sorry