Non-selected checkbox state?

[Guest]

Doesn't a checkbox have a non-selected state?

I'm using a combo box to designate
"Please Select"
"On State"
"Off State"

I thought that if a checkbox was never checked or unchecked it was ---Null?

 

[Ken Snell [MVP]]

Depends upon how you set up the field that is bound to the checkbox. If it's
a Yes/No field, then it has only two value possibilities: True or False.
Unchecked means False.

However, if the field is an integer type, then a checkbox control bound to
this field can have its "Triple State" property set to Yes, which means that
it can represent three value possibilities: True, False, or Null.

 

[Ron Kunce]

Checkbox or Combobox?

Access allows three states or only two states for a checkbox value. The
"Triple State" property of the checkbox control should yes to allow nulls.
When set to No, it only allows a yes/no, true/false, -1/0 state, which
defaults to 0 or false.

 

[Guest]

Strange. I DO have it set to tripple state - But I added this field late.
So, all existing records are automatically changing it to a zero state in my
interface.
but NEW records are at a null state. (which is what I desire)

So I tried doing an update query to set all fields to NULL, but no go.
it STILL sets my present records to 0. So as Ken Snell states... I think I
need to change the field to a textbox integer value and allow nulls on the
table.