>I have a problem when I try to save a null date into database.
>This is the scenario:
>
>Create a Access database with a table in it.
>The table has a date field(Required property set to no).
>Add a few date record into it: eg 1/1/90, 1/2/90, 1/3/90
>
>Create a VB form and put a data control onto the form
>Create a text field that bound to the date field in the data control.
>Create a command button that contain the following command:
>data1.updaterecord
>
>Run the project and move the current record to 1/2/90 and
>delete the contains of the field and press the command button.
>
>An error: Data conversion error occured.
>
>Can anyone help me to solve the above problem?
Perhaps this can help you. When using SQL & "saving" date to date fields in the db, you have to put them in this form: #12/7/90#
Alesh