How to delete the datetime field

[sanford101]

I have a textbox and ado data control on a form
The textbox is using the ado control and its datafield
is HireDate, which is datetime field on the sql table.

when I try to delete the date shown in the textbox, then click the ado data control's movenext button.
the ado control give me error message:

"change is canceled during notification, no column are changed"

after the massage, the date I try to wipe out come back to the textbox again.

Anybody know how to delete the date? Please kindly tell me.

Thank you very much for your time.

The AllowNull is checked on the field

[damonous]

You have to trigger the Update Event. Something like:

Public Sub cmdUpdate_Click()
adodc.update
End Sub

Also, be certain that you are not connecting to your database as "Read-Only".