Solved

Conditional Formatting only works when control has focus

Posted on 2016-11-08
4
21 Views
Last Modified: 2016-11-08
I am attempting to use conditional formatting on fields in a continuous form, but the conditional formatting only works when the field has the focus. When I click on the field, it selects the correct conditional formatting, but when I change to a different field, the conditional formatting turns off. I do not have conditional formatting set to "Field has Focus". Is there a setting I'm missing? I am using MS Access 2010 & 2013. Thanks!

Screenshot of conditional formatting
0
Comment
Question by:Joshua Raymond
  • 2
  • 2
4 Comments
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 500 total points
ID: 41879013
Check the background style of the control and make sure it is not transparent, should be "Normal"
1
 

Author Comment

by:Joshua Raymond
ID: 41879025
Dale, thank you so much! That did the trick!
0
 

Author Closing Comment

by:Joshua Raymond
ID: 41879039
Dale's insight was just what I needed to solve this issue I had!
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 41879042
glad I could help
1

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Max per month 3 15
Access Migration to Sql Server 2 22
Help with SQl and UNION 3 19
Error in query 3 0
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

744 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

12 Experts available now in Live!

Get 1:1 Help Now