newbie46
asked on
How do I remove the green background from Access 2007 checkboxes which are unchecked?
Please see the attached file. In reference to the boxes that are unchecked, you see that some have a green background and some have a white background. 2 Questions:
1) Why are some green and some white?
2) How do I set all unchecked boxes to have a white background?
Thanks.
Checkboxes.docx
Can you post a Doc instead of DOCX?
My guess ...
You can't set the bg of a check box, at least in in A2003.
It may be that the Green ones have never been click on ...?
mx
My guess ...
You can't set the bg of a check box, at least in in A2003.
It may be that the Green ones have never been click on ...?
mx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
capricorn1,
Triple state is already set to no.
Triple state is already set to no.
ASKER
Also, in the table, the default value for this field is set to 0.
ASKER
DatabaseMX,
I cannot post a Doc file. Maybe before I display this form, I can loop through all records and set the nulls to 0.
I cannot post a Doc file. Maybe before I display this form, I can loop through all records and set the nulls to 0.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Question Answered
try setting the Triple state property of the check box to NO