conditional formatting-date color change

[lbjcaj]

I wrote in Access 2003, having a little trouble. making this happen. What i'm
doing is on calibration dates for tools. I would like to have the date that i
put into [calibrationdue] change colors, 30 and 15 days before and turn Red
when past due. Can anyone help me? Dumbfounded. Lonnie

 

[John Spencer]

Open the report in design view
Click on the control
Select Conditional Formatting from the menu
Set condition 1
Between Date()-30 and Date()-15
Set condition 2
Between Date()-14 and Date()
Set Condition 3

Date()

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

I wrote in Access 2003, having a little trouble. making this happen. What i'm
doing is on calibration dates for tools. I would like to have the date that i
put into [calibrationdue] change colors, 30 and 15 days before and turn Red
when past due. Can anyone help me? Dumbfounded. Lonnie

 

[lbjcaj]

lbjcaj wrote: Thanks john, that works great, just had to change condition 3
<or =to, instead of >Date()
again Thanks alot.

Open the report in design view
Click on the control
Select Conditional Formatting from the menu
Set condition 1
Between Date()-30 and Date()-15
Set condition 2
Between Date()-14 and Date()
Set Condition 3

Date()

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

I wrote in Access 2003, having a little trouble. making this happen. What i'm
doing is on calibration dates for tools. I would like to have the date that i
put into [calibrationdue] change colors, 30 and 15 days before and turn Red
when past due. Can anyone help me? Dumbfounded. Lonnie