Help me, Please

[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.

[_bman_]

Is the date a required field?

[lychew]

did you check the allow null option for the date column??