-
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.
-
just a guess
Is the date a required field?
-
did you check the allow null option for the date column??