Using MS Access/Conditional Formatting

Advertisement


Question
Richard - I am using MS Access 2013.
I have created a report and would like to Print/Display a whole line of the report in Red if a condition = true.

Data looks like this
Fname   Surname  DoB       Platoon
John     Doe     19/06/67    Ford
Liz      Smith   29/05/64    Perm Staff
Billy    Kidd    14/04/68    Clayton

What I want to do is Print/Display all the Details of Liz Smith in Red because she is Perm Staff.
I have looked at the Conditional Formatting Rules and I can get the Platoon to Print/Display in Red for Liz Smith, however I can't see how to get the Fname, Surname and DoB to be in Red.

Do you have any solutions/suggestion to solve my problem.?

Answer
See this tutorial: CONDITIONAL FORMATTING EXPRESSIONS


Be sure to visit my web site and watch my FREE 2-hour-long Microsoft Access Video Tutorial

Cordially,
Richard Rost
599CD Computer Training

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Richard Rost

Expertise

I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site, and free Access 101 tutorial.

Experience

I am the president of AccessLearningZone.com and 599CD.com. I specialize in Microsoft Access Tutorials. I have been teaching Access in the classroom since 1994, and online since 2002.

Education/Credentials
I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at 599CD.com

©2016 About.com. All rights reserved.