Triple State not working for check box.


G

Guest

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.
 
Ad

Advertisements

K

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.
 
G

Guest

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


Ken Snell (MVP) said:
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.
 
G

Guest

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

Yeah that's the heart of it.

--
Regards
Tom


ThomasAJ said:
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?
 
Ad

Advertisements

K

Ken Snell \(MVP\)

ThomasAJ said:
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).
 

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

Top