• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 330
  • Last Modified:

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
0
newbie46
Asked:
newbie46
  • 4
  • 2
  • 2
  • +1
3 Solutions
 
Rey Obrero (Capricorn1)Commented:
that means, the check box is in Null state not -1 and not 0

try setting the Triple state property of the check box to NO
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Have not been clicked on or initialized to False (or True)

mx
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
newbie46Author Commented:
capricorn1,
Triple state is already set to no.
0
 
newbie46Author Commented:
Also, in the table, the default value for this field is set to 0.
0
 
newbie46Author Commented:
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.
0
 
Rey Obrero (Capricorn1)Commented:
set them all to False
0
 
Michael VasilevskySolutions ArchitectCommented:
Maybe set the default value of the form control to false? Or as MX said initialize to false on form open:

    Dim frm As Form, ctl As Control  
    Set frm = Forms!MyForm
   
    For Each ctl In frm
            Case Is = acCheckBox
                ctl.Value = False
        End Select
    Next ctl
0
 
newbie46Author Commented:
Question Answered
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now