|
| 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
February 22nd, 2006, 12:26 PM
posted to microsoft.public.access.forms
|
|||
|
|||
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
February 22nd, 2006, 12:33 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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
February 22nd, 2006, 12:46 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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 |
Linear Mode
