Triple State not working for check box.

[ThomasAJ]

Check box on tab, Triple State = Yes, break inside onclick event, click check
box and it's value is ALWAYS = 0.

Um... is there a bug here or is it me.

 

[Ken Snell \(MVP\)]

First, be sure that the field to which the checkbox is bound (if any) is an
Integer or Long Integer data type. Second, use the AfterUpdate event of the
option group control, not the option button.

 

[ThomasAJ]

Yeah OK that does work (thank you) but a boolean (yes/no) field is where most
(all) check boxes are used and that field can take values of -1,0,null.

The description of that property in the help states:
"The control will cycle through states for Yes, No, and Null values. The
control appears dimmed (grayed) when its Value property is set to Null."

I have a LOT of yes/no fields in a table that I cannot change but I need the
3 states.

What's going on here? Is my logic/knowledge that far out?

--
Regards
Tom

First, be sure that the field to which the checkbox is bound (if any) is an
Integer or Long Integer data type. Second, use the AfterUpdate event of the
option group control, not the option button.

 

[ThomasAJ]

Oh...Yes/No fields probably cannot take a NULL value.

Yeah that's the heart of it.

--
Regards
Tom

Yeah OK that does work (thank you) but a boolean (yes/no) field is where most
(all) check boxes are used and that field can take values of -1,0,null.

The description of that property in the help states:
"The control will cycle through states for Yes, No, and Null values. The
control appears dimmed (grayed) when its Value property is set to Null."

I have a LOT of yes/no fields in a table that I cannot change but I need the
3 states.

What's going on here? Is my logic/knowledge that far out?

 

[Ken Snell \(MVP\)]

Oh...Yes/No fields probably cannot take a NULL value.

Yeah that's the heart of it.

Correct. Yes/No fields can hold only Yes or No (True or False).