null date when entering into database through ado

I have a samall problem .When i enter a date value through a recordset object the sql statement does not execute.

i am getting this value from a textfield which is blank.
the idea is to enter date of birth which the user of the form may not know.so to allow null entries.
please help.
thanx

Make sure that DateField allows Null value. Then,


If (IsDate(MyForm.txtDate) = true) then
m_rs("DateField") = CDate(MyForm.txtDate)
else
m_rs("DateField") = null
End If
m_rs.Update





--Take the life as it comes--

Hi. Try the Nz function. It handles zero values.

Note about that, Nz is only available in VBA, not in real VB.

Tom Cannaerts
[email protected]

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook