Link to home
Start Free TrialLog in
Avatar of sandramac
sandramac

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
or

use

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

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

Avatar of sandramac
sandramac

ASKER

Hello i inputted the expressions but still no color change on the reports
can you post the expression that you used. better if you can upload your db
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