"Can't set value to null when checkbox property=false."

K

kevinjwilson

I get the message "Can't set value to null when checkbox
property=false." on a form when using the active x date picker
(MSComCtl2.DTPicker). I understand the reason for the error code, the
form feild is tied to a table field which is null unitill data is
entered. Does anyone know how to get around this issue and use the
date picker?
 
J

Joseph Meehan

I get the message "Can't set value to null when checkbox
property=false." on a form when using the active x date picker
(MSComCtl2.DTPicker). I understand the reason for the error code, the
form feild is tied to a table field which is null unitill data is
entered. Does anyone know how to get around this issue and use the
date picker?
Click to expand...

Are you trying to set the yes/no field to null? I don't believe that is
a valid state. It is 0 or -1 I don't believe null will work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to set the DTPicker default value thru VBA 1
date & time picker control ??? 2
set DateTimePicker value to null issue 1
Macro to modify property of an object 6
Cannot set value to NULL when checkbox property=FALSE 0
Date & Time Picker Properties Question 19
Finding Null Values 3
error...can't set value to null... 4

Top