ActiveX Date Picker Gives Error Message In Form

[Dave Gibson]

Hi,

I wonder if anyone can help me with a problem with an ActiveX control.

I have inserted an ActiveX date picker control into a form and linked
it to a date field in the underlying table. However, when I navigate
the records in the form I am getting error messages as below:

Cannot Set Value To NULL Whe CheckBox Property = FALSE

The message only seems to be appearing in the form for records when
the date field has a blank/NULL value.

I have altered the properties of the ActiveX control date picker for
"Checkbox" to "Yes" from "No"

That stops the error messages but I now have a tick box in the control
field to the left of the data part which looks out of place.

I tried a calendar control but it will not allow me to display it as a
simple field in dd-mmm-yy format in a small box, rather, it always
displays the calendar.

All I want is a calendar to pop up for date selection when I click the
drop down button of the date picker but without these error messages.

Any help gratefully appreciated as I am sure I am not the first person
to come acros this and nor will I be the last.

Many thanks in anticipation

Regards
Dave

 

[ManningFan]

DatePicker gave our company so much trouble I re-wrote it using the
Calendar control. No problems ever since.

 

[Allen Browne]

Hi Dave

There's a very simple little Access form in this link that you can include
in your database:
http://allenbrowne.com/ser-51.html

No references needed.
Works with d/m/y dates.

 

[Dave Gibson]

Allen,

Thank you ever so much, it works a treat and the instructions were
very clear to follow.

Regards
Dave