Filtering Check Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a database for a certain project. Since then, I have copied it
(without data) for a new project. I have around 10 of the databases now -
same database, just differenct projects. One of the forms we use have check
boxes. When I filter, I can see the check boxes greyed out (TRUE or FALSE).
Click then it has a check mark (TRUE) and click again it becomes blank
(FALSE). This works fine on my computer, but when my boss tries it (we tried
another employees computer also), they can select (TRUE/FALSE), (TRUE), or
(FALSE), BUT the (TRUE/FALSE) does not look greyed out. Mine looks fine, but
theirs do not. First we thought it was the display, but it works for them on
some of the databases, but not all. I've tried changing the check boxes to
options and back to check boxes again. I've tried to enlarge and even move
the boxes. Nothing works. Why is it on some database my boss can see the
greyed box and not others? Why is it OK no matter what database I bring up
and only some formy boss? Thanks.
 
The greyed check box (representing Null) does not show up correctly in
Access 2003 on Windows XP.

In that version, I believe you can work around the problem by unchecking:
Tools | Options | Forms/Reports | Use Windows Themed Controls

You can also solve the problem by right-clicking on the desktop of Windows
XP, and setting Themes to Classic.

There are some issues with this approach. Check boxes have a Triple State
property, and theoretically the null state should not be permitted if this
is set to No. But unless you set a Default Value for the check boxes, they
can initialize to Null, and they do that again after a Filter By Form.

The other issue is that Yes/No fields in JET tables (the data engine in
Access) cannot store Null, so if the check box is bound to a Yes/No field,
it cannot be Null, regardless of how its Triple State property is set. This
is a serious limitation of JET, and can cause Access to crash (shut down by
WIndows) if you do get nulls in a yes/no field (e.g. as the result of an
outer join with another table.)
 
Thanks Allen!!
It worked just fine after I unchecked the Use Windows Themed Controls.
Have a good weekend!
 
Back
Top