conditional formatting-date color change

  • Thread starter Thread starter lbjcaj
  • Start date Start date
L

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
 
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()
Click to expand...


'====================================================
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
Click to expand...
 
lbjcaj wrote: Thanks john, that works great, just had to change condition 3
<or =to, instead of >Date()
again Thanks alot.
John Spencer said:
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()
Click to expand...


'====================================================
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
Click to expand...
Click to expand...
 
Back
Top