?
Solved

Access 2007 - Conditional Formatting

Posted on 2011-02-16
1
Medium Priority
?
565 Views
Last Modified: 2012-05-11
I've got a report that displays a number of rows of data with multiple data items per row.

I need to apply conditional formatting to a row that will change the forecolor of the row to red if the end date is within 6 months of the current date.

I have found the place in Access where you configure the conditional formatting and I can tell that need to use the 'Expression Is' condition, but I'm not sure how to build my expression in order to get my desired result.

Thanks for help
0
Comment
Question by:JosephEricDavis
1 Comment
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 34911115
expression is datediff("m",[end date],Date())<=6

or maybe this


expression is datediff("m",[end date],Date())>=6
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
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.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

578 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