Question Yes/No field options

[Liesel]

I've just moved on to Vista and have a problem regarding filtering a table with a Yes/No field using filter by form. There are three options available: 'ticked', 'empty', 'either'. Using XP, these three options were very clear but now two of these options look exactly the same. Is there any way to change the display options to delineate between the 'empty' and 'either' options?

 

[FoFa]

Hummm, it would appear they mean CB = True, CB = False, CB = True OR False.
Quite a difference in my mind.

 

[Banana]

Erm, I should point out that if you're using Yes/No bound to the checkbox, Yes/No converts all "NULL" values to No/False/0, even though the checkbox can support 'triple state'. I'd shun using checkboxes especially one that with "either"/"neither"/"N/A"/whatever.

Rather, better to use combobox with list like this:

A
B
Either
Neither

with a lookup table.

 

[Liesel]

Sorry, I think this was the wrong forum to add this question. I'll look for an Access users forum instead. Thanks to everyone who considered this question and to those who responded.