option of blank in Yes/No check box in form

  • Thread starter Thread starter kim
  • Start date Start date
K

kim

HI,
I'm trying to add a check box to a form with Yes, No
options. I used option group to get the yes & No values
but I also want to collect the null or blank values. In
other words, the value of the check box in the form could
be "Yes", "No" or " "/Null. The field type can be Yes/No
or Text. I have tried both ways.
Thanks
 
That is called triple state.

Set up your field as triple state and you can have the three values you
mention.

Rick B
 
I know a little about it but couldn't find help about how
to setup the triple state. And if I set it as triple
state, what changes do I need to make to the field type,
what the check box should look like. I have no Idea. All I
need to see on the form is Yes and No option, but if
neither of those two are checked, make the values null or
blank. Can you please suggest how?
Thanks
 
On your form and table, set the chcekbox as triple state. On the form, you
will see grayed out for null, checked for yes or -1 and empty box for no or
0.

Rick B
 
Note that if such a textbox is _bound_, it must be bound to a Field
which is defined as _Numeric_ (generally Integer), _not_ as Boolean
(Yes/No) . In Access, a Boolean Field (contrary to Codd!) cannot
contain a Null value. You can, however, (and probably should) treat
such an Integer field exacty as if it were a Boolean field that has
the additional capability of containing a Null value

On your form and table, set the chcekbox as triple state. On the form, you
will see grayed out for null, checked for yes or -1 and empty box for no or
0.

Rick B
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Back
Top