Change font color

Hello, newbie to MS Access.  Trying to figure out how to when I run a report to have the dates on my report that are 30 days or older from the current date to be color font red and bold, If within 1-30  days the font is yellow and bold, else nothing.
sandramacAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
use conditional formatting, select the controls click Format> conditional formatting

use

expression is DateDiff("d",[txtDate],Date())<=30
          yellow

expression is DateDiff("d",[txtDate],Date()) > 30
       red

0
 
Rey Obrero (Capricorn1)Commented:
or

use

expression is DateDiff("d",[txtDate],Date()) between 1 and 30
          yellow

expression is DateDiff("d",[txtDate],Date()) > 30
       red

0
 
sandramacAuthor Commented:
Hello i inputted the expressions but still no color change on the reports
0
 
Rey Obrero (Capricorn1)Commented:
can you post the expression that you used. better if you can upload your db
0
 
sandramacAuthor Commented:
Okay i got it to work, but the cell will only format when i click on the value on the report when i click on a different date
access.jpg
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.