?
Solved

Conditional Formatting on a Report

Posted on 2015-02-11
2
Medium Priority
?
82 Views
Last Modified: 2015-02-11
Experts, I have a report with a field [Due Date per docs] (I know this is not named correctly but it is an import from excel data).   I have another field [Description] and I need to conditionally format this field [Description] if [Due Date per docs]>Date() And Date()+10 but this doesnt seem to conditionally format  [Description].  In the Rules Manager I have Expression is:   [Due Date per docs]>Date() And Date()+10 then I hit apply.

How can I conditionally format this field [Description] based on the criteria of [Due Date per docs]>Date() And Date()+10

thank you
0
Comment
Question by:pdvsa
[X]
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
2 Comments
 
LVL 48

Accepted Solution

by:
Dale Fye earned 2000 total points
ID: 40603349
You might try:

Expression: ([Due Date per docs] > Date()) AND ([Due Date per docs] < Date() + 10)
0
 

Author Closing Comment

by:pdvsa
ID: 40603480
Perfect!  

([Due Date per docs] > Date()) AND ([Due Date per docs] < Date() + 10)
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

770 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