If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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." |
#2
|
|||
|
|||
Greying Out Null Checkboxes
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." |
#3
|
|||
|
|||
Greying Out Null Checkboxes
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." |
Thread Tools | |
Display Modes | |
|
|