I have a DTPicker on my form and I want to be able to leave it blank and have a blank date in my Access database if the user doesn't select a date - I can't get it to default to blank if there's no data in the field - any ideas?
Printable View
I have a DTPicker on my form and I want to be able to leave it blank and have a blank date in my Access database if the user doesn't select a date - I can't get it to default to blank if there's no data in the field - any ideas?
Set the CheckBox property to true. The DTPicker won't show as blank if the field has a null(blank) value, but it will be partially grayed and unchecked. I'm not sure how this will work for inputting data since I have not used DTPickers in this manner, but theoretically it should be okay if you have the DTPicker's data source set to the proper field.