3-way property of boolean variable

[lulu]

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

 

[Duane Hookom]

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".

 

[Rick B]

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.

 

[Pat Hartman\(MVP\)]

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.

 

[mnature]

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]

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

 

[lulu]

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...