?
Solved

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

Posted on 2010-09-24
9
Medium Priority
?
325 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
  • +1
9 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
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 - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 664 total points
ID: 33756292
Have not been clicked on or initialized to False (or True)

mx
0
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 

Author Comment

by:newbie46
ID: 33756313
capricorn1,
Triple state is already set to no.
0
 

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 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 668 total points
ID: 33756361
set them all to False
0
 
LVL 10

Assisted Solution

by:Michael Vasilevsky
Michael Vasilevsky earned 668 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

743 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