Greying Out Null Checkboxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kdagostino - 04 Apr 2008 16:06 GMT

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

Reply to this Message

Allen Browne - 04 Apr 2008 16:24 GMT

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.

Signature

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.

>I have a search form where values entered become the criteria for a query.
>I
[quoted text clipped - 10 lines]
> 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."

Reply to this Message

kdagostino - 07 Apr 2008 14:31 GMT

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

> Try turning off the 'Use Themed Controls' in Access.
>
[quoted text clipped - 22 lines]
> > 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."

Reply to this Message