I've developed a Faults database - Access 2007.adp/SQL2008. I'm displaying all OPEN faults via a form in datasheet view. I'm trying to colour code the Elapsed Time (Hours and Minutes) of any OPEN fault that has been OPEN for more than 2 Hours in Red. If Under 2 hours then leave white. It would appear that when the form is loaded it takes the settings of the first record as the default and colours all the displayed records as per the first record settings - see attached "FaultsProblem1.png". If I click on a specific record then it takes that record's settings as the default and applies them to all the displayed records see "FaultsProblem2.png".
What I would like to achieve is to set the back colour of each individual record displayed according to each records Elapsed Time. Is this possible or am I just wasting my time.