ActiveX Date Picker

[Bobby Bosco]

When I use the datepicker in a form that opens for data
input only, I get the following error. Seems that I get
this error for every instance of datepicker I have on my
forms and subforms...

Can't set Value to NULL when CheckBox property = FALSE.

The users LOVE the datepicker and would like me to put it
on all forms. However, I don't know how to get around
this problem. Any suggestions would be greatly
appreciated.

tia

Bobby Bosco

 

[Neil]

Hello Bobby,

This has something to do with the date picker not being able to have a null
value when it is enabled - which is what the value is on a new record. I am
assuming that you have the date picker bound to a field in a table. If so,
could you have a default date that could be shown instead of nothing? For
example, if you put =Date() in the fields default value, then it will
display todays date as the default.

HTH,

Neil.

 

[Newbie]

I set all my values for the DatePicker control in the OnLoad event of the
form rather than the open event and don't have any problems

HTH

 

[Bobby Bosco]

Having read both responses I feel rather foolish. Geez, I
should have thougth of that since I set other things on
the ONLOAD and ON OPEN events.

Install Brain and REBOOT!

Thanks

Bobby Bosco