Solved

Change font color

Posted on 2011-02-11
5
331 Views
Last Modified: 2012-05-11
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
Comment
Question by:sandramac
  • 3
  • 2
5 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 34874140
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
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34874151
or

use

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

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

0
 

Author Comment

by:sandramac
ID: 34874449
Hello i inputted the expressions but still no color change on the reports
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34874479
can you post the expression that you used. better if you can upload your db
0
 

Author Comment

by:sandramac
ID: 34874546
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

809 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