If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
CheckBox
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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200602/1 |
#2
|
|||
|
|||
CheckBox
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 --------------------------- "red skelton via AccessMonster.com" u15475@uwe wrote in message news:5c4255c01465a@uwe... 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200602/1 |
#3
|
|||
|
|||
CheckBox
Thanks Graham,
I've never noticed the triplestate property before :/ Thanks, Red Graham R Seach wrote: 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] red -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200602/1 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Checkbox command | hsdaguilar | Using Forms | 2 | May 11th, 2005 04:20 PM |
Checkbox Click w/o AfterUpdate Firing????? | JP | Using Forms | 2 | April 11th, 2005 03:48 PM |
Checkbox | Chip1035 | Using Forms | 9 | April 6th, 2005 10:19 PM |
Field View when checkmark in checkbox | Chip1035 | New Users | 3 | March 17th, 2005 05:49 PM |
How to hide checkbox when the datasource contain bool value | Abhi poddar | Setting Up & Running Reports | 3 | December 23rd, 2004 12:52 PM |