Greying Out Null Checkboxes

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

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"kdagostino" wrote in message
...
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."

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

"Allen Browne" wrote:

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"kdagostino" wrote in message
...
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."