Greying Out Null Checkboxes

[kdagostino]

I have a search form where values entered become the criteria for a query. I
have several checkboxes on the form. The default value is Null, so that when
the user does not check/uncheck the box, the query searches for either value.

My problem is that the checkbox does not appear any different when it is
null or when a "No" value is selected. Is there a way I can grey-out the
checkbox when it is Null?

Also, I would consider changing the "Triple State" value to "Yes" so that
the user could cycle through "Yes" "No" and "Null" but I have the same
problem. There is no way to tell whether the checkbox is "No" or "Null."

 

[Allen Browne]

Try turning off the 'Use Themed Controls' in Access.

In Access 2007, that's under Office Button | Current Database
In Access 2003, it's under Tools | Options.

The other alternative is to set your Windows Themes to "Classic."

Before Windows XP, the check boxes used to show the 3 states correctly.
These days, I suggest that a triple-state check box is not a useful
interface. Perhaps it might be better to use a combo where it's obvious is
the user has left it blank.

 

[kdagostino]

Thank you so much. I turned off 'Use Themed Controls' and it works perfectly.