Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 343
  • Last Modified:

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.
0
sandramac
Asked:
sandramac
  • 3
  • 2
1 Solution
 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now