Can two fields control one conditional format in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to change the format of one field based on the dat in that field and
tthe status of another. That is if the date is older than 5 days and the
"closed" feld shows that it is still an open record then the Date should
change to the colour red and a large font.

Can this be done and if so how?
 
I want to change the format of one field based on the dat in that field and
tthe status of another. That is if the date is older than 5 days and the
"closed" feld shows that it is still an open record then the Date should
change to the colour red and a large font.

Can this be done and if so how?
Click to expand...

Yes; use the "Expression" option in conditional formatting, and put
any logical expression which evaluates to either True or False. E.g.

[Closed] = False AND [Date] < DateAdd("d", -5, Date())

John W. Vinson[MVP]
 
Back
Top