Solved

How do I remove the green background from Access 2007 checkboxes which are unchecked?

Posted on 2010-09-24
9
316 Views
Last Modified: 2012-05-10

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
Comment
Question by:newbie46
  • 4
  • 2
  • 2
  • +1
9 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 33756286
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
 
LVL 75
ID: 33756287
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
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 166 total points
ID: 33756292
Have not been clicked on or initialized to False (or True)

mx
0
 

Author Comment

by:newbie46
ID: 33756313
capricorn1,
Triple state is already set to no.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:newbie46
ID: 33756325
Also, in the table, the default value for this field is set to 0.
0
 

Author Comment

by:newbie46
ID: 33756344
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
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 167 total points
ID: 33756361
set them all to False
0
 
LVL 10

Assisted Solution

by:Michael Vasilevsky
Michael Vasilevsky earned 167 total points
ID: 33756369
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
 

Author Closing Comment

by:newbie46
ID: 33756578
Question Answered
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now