MSComCtl.DTPicker on an Access form

[Guest_imported]

I have a MSComCtl.DTPicker on an Access form.
The control source is set to a date field (data type Date/Time).
In the properties I have the value set to the date.
I get an error message: "Can't set value to NULL when CheckBox property
= FALSE." when adding a new record. Any ideas??

 

[lionelbrown]

I ran into the same problem with a VB app. If you don't always want a date to be used, you can turn on the checkbox property. If you don't want the checkbox and always expect a date to be entered, this is what I did:

To work around it I used the control without binding it to a field. When moving to an existing record I set its value to the appropriate value contained in the database. When moving to a new record, I set its value to the current date (using now() or some other function that returns the current date). When a record is updated (new or existing record), I grabbed the value out of the unbound control and put it in the appropriate field of the recordset (I think, in my case, I used the WillChangeRecord event). I think you can do all of this in Access, of course the events, etc. may be different.