DateTime Picker Control

[mthaddon]

Hi folks,

Does anyone know how to save a null value of a dtpicker control to a database (ie when the user unchecks the checkbox, indicating that he/she doesn't want to select a date). How do I check if the checkbox is selected and/or return the checkbox as selected?

Thanks guys.

------------------
Tom Haddon

[TEG]

Tom, to save the null value just use the .value property of the control to save against the database. I don't think there is a checked property on the control, but again you can use the .value property to see if the value is Null. On this control, as far as i've seen, the only way to set the value to a null is to uncheck the box. This control is a nice new feature packaged in VB, however, like every other MS control, they could have spent a little more time developing it... How about a locked property and how about clearing the box when the checkbox is not checked???? Add these to features to this control and it would get my vote for control of the year.

[mkarjadi]

hi,

I've had problem with dtPicker.
How do we bind the field from RecordSet in ADO to dtPicker?
I can do it by whenever the table contain no records, it fails saying can not be bind, know why?

Thanks for the help