Conditional formatting

[Guest]

I am trying to conditional format a report for Passports to highlight when Passports are about
to expire. My conditional formatting is affecting every passport. please help and step me thr
how to get the blasted date to print in red if it is within 6 months of expiring thanks!!!

 

[fredg]

I am trying to conditional format a report for Passports to highlight when Passports are about
to expire. My conditional formatting is affecting every passport. please help and step me thru
how to get the blasted date to print in red if it is within 6 months of expiring thanks!!!

Which version of Access?
Access 2000 or later, you can use the Date control's Conditional
formatting property.

In Design View, select the [DateField] control, then click on
Format + Conditional Formatting

Set the Condition1 Dropdown to
Expression Is
Set the expression to
DateDiff("m",[DateField],Date()) Between 0 and -6

Select the colors you wish.
Save the changes

What do you want to do if the expire date has already past?
You can adapt the above to handle that also.