Yes/No Boxes Design

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

Is there any way that I can actually have two different
yes/no boxes in the same field?

For example, I have a database of companies that I am
gathering information about, and I need to know if they
sell product X. If I leave the database like it is, I
can check the yes/no box if they have it, but leave it
blank if they don't have it. However, if the box is
blank there isn't a way to tell if I've asked them.

Rather than making another field column of check boxes to
see if i have asked them i would rather just have two
actual check boxes in the field column of "do they offer
product X"

Any ideas?

Thanks to any who answer,

Kevin
 
Great minds think alike ah Armen!!!!

Sam said:
I agree with John, the field needs to be an Integer, however you can use a
checkbox on your forms. Check boxes have a property called TripleState, set
this to True. Now the checkbox will cycle through three states corresponding
to Null (greyed out interior), O (no tick), and -1 (ticked).

Oh, you'll have to use an Integer type not Byte, as you need -1. Also the
default value for the field needs to be Null.

HTH
Sam
Click to expand...
 
Just use a Number/Integer field, and bind it to a checkbox on your form.
Make sure the Triple State property is Yes. Then, null values will show
as a "grey" value, false are white, and true is a checkmark. This is a
feature in Access 2000 and later.
Click to expand...

One disadvantage, however, is that it takes 2 clicks to answer "No". Other than
that, it will do the trick.
 
Back
Top