Why is Conditional Formatting not working on the last two items?

I have a table and a form that I attached which is all part of the actual problem.

The last two text boxes on the form "Selecte8" and "Select9" are not being affected by Conditional formatting when the check box is checked?

I have tried replacing bothe the form and tyable and still have the same problem
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

The names of the last two checkboxes are not consistent with how your other checkboxes are named.  Check them and you'll see why.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Having said that, adding fields to a table in order to mark a checkbox as selected is BAD DESIGN!  You can easily accomplish the same thing by adding a textbox to your form with the following expression:
=IIf([ProActive Analysis],"Selected","")

I would also venture to say that your table is not well designed.  You would do well to read up on Relational Databases and design your tables accordingly.  Otherwise, you are asking for a mountain of problems to surface later on when the scope of your database grows.

Here are a couple of videos you should take some time to view:
MS Access – Basics of Designing Tables
MS Access – Working with Relationships

cssc1Author Commented:
I corrected the names of the last two text boxes, same problem, See attached image
You misunderstood me.  I said the name of the Checkboxes, not the name of the field.
Hamed NasrRetired IT ProfessionalCommented:
As commented by IrogSinta, you need to redesign the database.

Check the attached modified database for the first check box which colors the label red when selected and black if not. See if you can make use of it.

If you need the selected text to show you may apply what  IrogSinta suggested. I added that to the first check box.

The label color, needs to be checked at open event.
The selected text works all the time.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.