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?
Printable View
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?
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
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