Null dates allowed

[Caro]

I have a text box linked to a data control date field which may or may not be present - If I blank it out and then update I get an error how do I create a null date in my text box?

[Bigley]

If there is a possibility that you are going to be setting a text box value to a null field value you should include double quotes before hand as follows

text1 = "" & recordset!myDate

[SteveFlitIII]

Has the database field got AllowNulls? set to NO if it has set it to YES. This will allow you to update the field with a NULL value