Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Conditional Formatting only works when control has focus

Posted on 2016-11-08
4
Medium Priority
?
221 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 49

Accepted Solution

by:
Dale Fye earned 2000 total points
ID: 41879013
Check the background style of the control and make sure it is not transparent, should be "Normal"
2
 

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 49

Expert Comment

by:Dale Fye
ID: 41879042
glad I could help
1

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

926 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