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
Solved

How to conditional format a checkbox based on if checked or not?

Posted on 2015-02-20
6
113 Views
Last Modified: 2015-02-23
I am trying to conditional format a checkbox on a form based on if it is checked or not?

The condition format option in MS access 2013 does not have this option.
0
Comment
Question by:cssc1
  • 3
  • 2
6 Comments
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 250 total points
ID: 40622242
CF is not available on a CheckBox - ever.

In a way, they are 'self CFing' ... either a check mark shows or not. You just can't add color ...

mx
0
 
LVL 35

Accepted Solution

by:
PatHartman earned 250 total points
ID: 40625076
As Joe indicated, the checkbox does not support conditional formatting.  If you want to do something visual, you will need to find or make a graphic and stack the images then make the one you want to see visible.
0
 
LVL 75
ID: 40626242
Pat basically repeated (agreed with) what I said, so it's not clear why she got the Accepted answer?
Just sayin' ..
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 35

Expert Comment

by:PatHartman
ID: 40626318
I guess you didn't read my suggestion regarding HOW to solve the problem that you identified.
1. Identification.
2. Solution.

You identified the problem, I agreed and offered a SOLUTION.
0
 
LVL 75
ID: 40626850
Actually, I answered the question.  I could ... have offered various solutions, but the OP made no hint of wanting one.  Also ... almost any solution, when applied to multiple check boxes ... probably is not worth the time ... which is another reason I did not initially suggest any solution,

mx
0
 

Author Comment

by:cssc1
ID: 40627119
Thanks for the help
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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 …

809 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