Hi All
My first post.
I know that this has been asked before = yes did search and the results helped me but didn't quit fix my problem.
I have an Access DB, Version 6.3 ASP runner.
I am trying to change the background colour of each row that matches criteria. Basically I want the row background colour to change to Red if the date in the cell ReAuditDate is less than todays date (highlighting that a reaudit is due. I do not want all rows in the list to change colour, just the one's that match the criteria.
I have added an event on the Listpage After Record Processed
If data("ReAuditDate") < "now()" then
row("rowstyle")="style=""background:pink"""
end if
The above changes every row in the list to Red (even the ones with a date greater than today.
Thanks in advance for any help.
Chicka
