Formatting

[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

 

[Duane Hookom]

You should be able to use Conditional Formatting from the Format menu.

 

[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

 

[Duane Hookom]

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.

 

[Chi]

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

 

[Chi]

Hi Duane,

Thank you so much for your patience and help! Finally, I got what I wanted.

Chi