Yes/No Boxes Design

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
 
S

Sam

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
 
B

Bruce M. Thompson

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.

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

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