CheckBox

  • Thread starter red skelton via AccessMonster.com
  • Start date
R

red skelton via AccessMonster.com

Hi everyone,
Can anyone tell me if it is possible to use a checkbox that has three
possible answers vs two? What I'm looking for is a control that will allow a
user to check either, yes, no or n/a. I've also tried do do this with
grouping but no luck. It doesn't matter if it is a checkbox or a radial
button but it needs all three choices and associated information stored in
the table but dont think I can use the yes/no data type in table either. Any
help would be greatly appreciated.

Many Thanks,

red
 
G

Graham R Seach

Yes, a checkbox can be triple-state; True, False, and Null.

Set the CheckBox's TripleState property to True, and make sure the table
field to which it is bound in a numeric datatype (usually an Integer) - not
a Boolean (Yes/No).

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia
 
R

red skelton via AccessMonster.com

Thanks Graham,
I've never noticed the triplestate property before :>/
Thanks,
Red
Yes, a checkbox can be triple-state; True, False, and Null.

Set the CheckBox's TripleState property to True, and make sure the table
field to which it is bound in a numeric datatype (usually an Integer) - not
a Boolean (Yes/No).

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia
---------------------------
Hi everyone,
Can anyone tell me if it is possible to use a checkbox that has three
[quoted text clipped - 10 lines]
 

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