Dear all,

I have a form in Acces and have some textbox to enter date which will be
insert to a field with date format in Access. However, if user does not enter
date in date textbox (key in nothing) when I try to save Access table there
ia an error 'Type mismatch'. I think the error is that the field with date
format in Access table can not get the null value from a textbox(value may be
"").

Could any one can help me on this problem! Or can give a function that can
convert the textbox to null value that then can be saved to Access table
field.

Thank you very much.