Conditional Formating a Control based off of Order Date Age

[dragongunner0351]

Hello all (Access2003 DB)
I have a subform that displays in list view, one of the controls is an OrderDate, I would like to change the background color to red (for the whole row if possible) if the Order is 15 days old.

I've tried the following conditional format: Expression is:
[Order_Date]+15>="Date"

But nothing, any help is always appreciated

Thank you.

 

[dragongunner0351]

My apologies I wrote List View I meant DataSheet View

 

[TheAceMan1]

How are ya dragongunner0351 . . .

Try:

[blue][Order_Date] + 15 >= Date[purple][b]()[/b][/purple][/blue]

See Ya! . . . . . .

Be sure to see thread181-473997

 

[dragongunner0351]

Worked great thanks Ace