Can't set value to Null When Checkbox property = False 1

[BajanPOET]

I've been getting this error intermittently when I'm trying to move between records "Can't set value to Null When Checkbox property = False" What does this mean and how do I get over it?

What? Who? ME????

 

[jadams0173]

I've had similiar issues before and found that checkboxes for the most part are TRUE or FALSE, 0 or -1 , Yes or NO depending on how that field in your table is defined. Maybe try one of those values instead of NULL.

I tried to have patience but it took to long! -DW

 

[BajanPOET]

I just don't see where I'm setting this checkbox to Null....

What? Who? ME????

 

[SgtJarrow]

Do you have the field in the table to which the checkbox is linked set to not accept nulls? If you do, and never touch the checkbox on the form, it may be passing a null back to the table and therefore triggering the error you are getting.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[BajanPOET]

So how can I tell if the field is set to not accept nulls and change it if necessary?

What? Who? ME????

 

[SgtJarrow]

Go to the table design, open in design mode, find the field for the checkbox and see if the REQUIRED property is set to true.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[PHV]

For me, JetSQL doesn't admit tristate boolean fields.
Have you tried to set the checkbox's default value to False ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[BajanPOET]

The required field isn't set to true... Setting the default value to false seems to have worked.

Thanks

What? Who? ME????