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