Question Yes/No field options (1 Viewer)

L

Liesel

New member

Local time

Today, 21:18

Joined

Jul 15, 2008

Messages

2

• Jul 15, 2008

• #1

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

Registered User.

Local time

Today, 15:18

Joined

Jan 29, 2003

Messages

3,672

• Jul 15, 2008

• #2

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

 

B

Banana

split with a cherry atop.

Local time

Today, 13:18

Joined

Sep 1, 2005

Messages

6,318

• Jul 15, 2008

• #3

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:

Code:Copy to clipboard

A
B
Either
Neither

with a lookup table.

 

L

Liesel

New member

Local time

Today, 21:18

Joined

Jul 15, 2008

Messages

2

• Jul 16, 2008

• #4

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.