Conditional formatting: red text for appts in coming week.

[NC_Sue]

One of my reports lists upcoming appointments. I want to appointments for the
coming week to "stand out". How do I do this?

I always have problems with figuring out how to direct Access to do
something-or-other based on dates.

 

[Jeff Boyce]

Have you looked into using the Tools | Conditional Formatting feature?

Have you looked into using VBA code that runs when the report is formatted?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[John Spencer]

In conditional formatting
Field Value is /// Between /// Date() /// and /// Date() +6
For today and the next 6 days (one week)

For tomorrow and the next 6 days
Date()+1 and Date() +7

That assumes that your date field is a datetime field.

 

[John Spencer]

Yes, but in that case you will need to use an expression.

Something like the following.


Expression is /// [DateControl] Between Date() and Date()+6

-- Select "Expression Is" from the combobox
-- in the blank box enter the expression

You will have to do this for each control on the report. I suggest you play
with one control and get it working. Then you can set each of the others.

--
John Spencer
Access MVP 2002-2005, 2007

Hey John - Can I change the formatting of all the fields in the row...
i.e.
including the name... based on the conditional formatting expression for
the
date?