error when submit new DATE records

[Barbaraa]

I have to insert new records by a add_form.asp. the
database is access. When I submit a record,
if the DATE textbox is empty, I have an error because it
appear access doesn't want empty record in date field!!
I said "yes" to allow null in table properties
Can someone help me?
this is the error:

[ODBC Microsoft Access Driver] Data type mismatch in
criteria expression.

thanks,

Barb

[Aaron Bertrand - MVP]

Null and "" and "##" are not the same thing!

Maybe you should say this:

if request.form("dateTextBox") = "" then
dt = "NULL"
else
dt = "#" & request.form("dateTextBox") & "#"
end if
sql = "UPDATE table SET dtColumn = " & dt & " WHERE ... "



"Barbaraa" <anonymous@discussions.microsoft.com> wrote in message
news:0ab601c39cad$b2348ed0$a501280a@phx.gbl...

> I have to insert new records by a add_form.asp. the
> database is access. When I submit a record,
> if the DATE textbox is empty, I have an error because it
> appear access doesn't want empty record in date field!!
> I said "yes" to allow null in table properties
> Can someone help me?
> this is the error:
>
> [ODBC Microsoft Access Driver] Data type mismatch in
> criteria expression.
>
> thanks,
>
> Barb