|
| 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 6th, 2006, 07:07 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
3-way property of boolean variable
is it possible to create a boolean variable (typically yes/no,
true/false, etc.) to also reflect a thrid option "n/a"? if so, how do you do it? I assume it is done somehow in the field's property definition. If this is not possible, what is my best alternative? An Option box? thanks! lulu 
|
|
#2
February 6th, 2006, 07:23 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
3-way property of boolean variable
I rarely use yes/no data types since there always seems to end up being more
than 2 required values. I suggest an integer field. If you can't switch fields, you can set a yes/no field to Null. Null can be displayed on a form or report as "n/a". -- Duane Hookom MS Access MVP -- "lulu" wrote in message oups.com... is it possible to create a boolean variable (typically yes/no, true/false, etc.) to also reflect a thrid option "n/a"? if so, how do you do it? I assume it is done somehow in the field's property definition. If this is not possible, what is my best alternative? An Option box? thanks! lulu
|
|
#3
February 6th, 2006, 07:27 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
3-way property of boolean variable
Take a look at "triple state" in the help files. You have to store the
value as a "-1" a "0" or as null, but you can use a checkbox to represent this. A checked box is true, a blank box is false, and a gray box is n/a. -- Rick B "lulu" wrote in message oups.com... is it possible to create a boolean variable (typically yes/no, true/false, etc.) to also reflect a thrid option "n/a"? if so, how do you do it? I assume it is done somehow in the field's property definition. If this is not possible, what is my best alternative? An Option box? thanks! lulu
|
|
#4
February 6th, 2006, 09:53 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
3-way property of boolean variable
Once you change the value in a check box, there is no way to set it back to
null via a form unless you do it with code. Given that, I would recommend a combo or option group. "Rick B" Anonymous wrote in message ... Take a look at "triple state" in the help files. You have to store the value as a "-1" a "0" or as null, but you can use a checkbox to represent this. A checked box is true, a blank box is false, and a gray box is n/a. -- Rick B "lulu" wrote in message oups.com... is it possible to create a boolean variable (typically yes/no, true/false, etc.) to also reflect a thrid option "n/a"? if so, how do you do it? I assume it is done somehow in the field's property definition. If this is not possible, what is my best alternative? An Option box? thanks! lulu
|
|
#5
February 6th, 2006, 10:25 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
3-way property of boolean variable
Set data type to text
Set Field Size to 3 In Validation Rule type: ="yes" Or "no" Or "n/a" In Validation Text type: You must enter either yes, no, or n/a "lulu" wrote: is it possible to create a boolean variable (typically yes/no, true/false, etc.) to also reflect a thrid option "n/a"? if so, how do you do it? I assume it is done somehow in the field's property definition. If this is not possible, what is my best alternative? An Option box? thanks! lulu
|
|
#6
February 7th, 2006, 05:02 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
3-way property of boolean variable
ok, i changed the properties of the fields on the input form to "triple
state" = yes. I have several dummy records in there but now i cannot edit, or add new records. the input form seems to be "frozen". help! delete the dummy records?? any suggesions? i have 108 elements that i need to collect input on, so doing an option explicit in VBA would be cumbersom, but if it is the only way...ouch. lulu
|
|
#7
February 7th, 2006, 05:04 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
3-way property of boolean variable
ahh-hh! i think i encountered this - as i had some dummy records in,
set the property to "triple state" in the form and now I cannot enter any data, it is sort of "frozen". What if I try deleting all my dummy records ... I am suggesting trying this as i have 108 data elements and making an option group takes a lot of space. any suggestions? thank you all wise and wonderful folks... Pat Hartman(MVP) wrote: Once you change the value in a check box, there is no way to set it back to null via a form unless you do it with code. Given that, I would recommend a combo or option group. "Rick B" Anonymous wrote in message ... Take a look at "triple state" in the help files. You have to store the value as a "-1" a "0" or as null, but you can use a checkbox to represent this. A checked box is true, a blank box is false, and a gray box is n/a. -- Rick B "lulu" wrote in message oups.com... is it possible to create a boolean variable (typically yes/no, true/false, etc.) to also reflect a thrid option "n/a"? if so, how do you do it? I assume it is done somehow in the field's property definition. If this is not possible, what is my best alternative? An Option box? thanks! lulu
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Passing Variable HELP HELP HELP | Hansford cornett | New Users | 6 | August 15th, 2005 05:23 PM |
| DAP DAP DAP...Who is the expert here? | vrk1 | General Discussion | 12 | August 12th, 2005 03:13 PM |
| List Box ListCount property seems to be incorrect... | Bob Howard | Using Forms | 7 | August 5th, 2005 05:40 AM |
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Daniel | Worksheet Functions | 1 | July 9th, 2005 03:05 AM |
| Can I use a variable in my OrderBy Property? | Bill Mitchell | Using Forms | 2 | August 17th, 2004 08:57 PM |
Linear Mode
