Conditional format past due date

  • Thread starter Thread starter Kelli T.
  • Start date Start date
K

Kelli T.

Fairly new Access user here. I have a report with a due date that I would
like to change the format on when it becomes due, but seems to be quite a
challenge for me. Any help is appreciated.
 
Kelli,
We need more information...
What is your field name?
What consitutes "becomes due?"
(ex. Due date is less than or equal to the date the report is run?
What would you like to do to the format if "due?"
(ex. Forecolor is black by default, but red when "due")

Let's assume the above examples are true and the field is named DueDate.
C/F...
Field Value Is | Equal to or Greater Than | Date()
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
You did it! That's exactly what I needed. I wasn't thinking to use the
Date(), but was trying to use the value stored. Thank you very much!
 
Back
Top