Change Back Color based on date range 1

[famehrie]

I will try to explain as best I can

I have a continuous form displying multiple records. There is a text field formated for a medium date which displays the date the record was last updated. I want to make it so if this date is 5 days old that the back color of this field will change to yellow for that record and not the entire record set. I have tried the following code I found in a similar thred in the forms Load event but it changes all of the records in the record set regardless of date.
If ((Date > (Me.txtLastUp + 5))) Then
Me.txtLastUp.BackColor = vbYellow

Any Help would be greatly appreciated.

 

[ZmrAbdulla]

If you are using Access 2000 or higher then please look for conditional formatting in the help menu.
or
While you are at the design view of the form
TOOLS > CONDITIONAL FORMATTING

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[famehrie]

ZmrAbdulla

Thank You. Thats exactly what I was looking for.