ActiveX Date Picker

  • Thread starter Thread starter Bobby Bosco
  • Start date Start date
B

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
 
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.
 
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
 
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
 
Back
Top