Conditional formatting: red text for appts in coming week.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NC_Sue - 02 Jan 2007 12:02 GMT

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.

Signature

Thanks for your time!

Reply to this Message

Jeff Boyce - 02 Jan 2007 13:29 GMT

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

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

Signature

Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

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

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

> 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.

Reply to this Message