Null Help!

[Guest]

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.

 

[Ken Snell [MVP]]

Normally, having a textbox bound to a Date/Time field and having a Null
value in that textbox will not cause a Type Mismatch error when the form
saves its data.

The fact that you get this error suggests that your form is doing something
with the value from that textbox before you save the form's data? Please
give us more details about what you're doing.