Formatting

  • Thread starter Thread starter Chi
  • Start date Start date
C

Chi

Hi,

I have a report that shows next three and six month appointments from the
first visiting. The appointment dates are different from each patient so it
is hard for me to know who I will see soon.

Ex: First visiting three month later six month later
1/22/09 4/24/09 7/22/09
4/30/09 7/30/09 10/30/09
5/04/09 8/04/09 01/014/10

Is there a way to format the dates( from the list above) that are close to
today will have red color ? In my example, the 4/24/09 should be in red.

Please help

Thank you in advance
Chi
 
Hi Duane,

Thank you very much for your help!

Would you please show me how to write a expression that will make the dates
are before or after TODAY are in red since I don't see the option for TODAY
under "Field Value Is"?


Thanks
Chi
 
You can use Date() to return the current date. You can also select
"Expression Is" from the Condition drop down to reference fields other than
the control you are formatting.
 
Hi Duane,

Again, Thank you so much! That is very nice option in Access! I got today
date in red! However, I would like to have that the three days before and
after today are in red.

please help
Thanks
Chi
 
Back
Top