I have been trying to colour certain fields within the form when their value
differs to that of another field in the same row. I have 7 fields which are
checked against 7 preceeding fields in a display of some 60 rows. I would
like to colour the checked fields in Red if they exceed, Orange if equal or
Black if less than the comparison field. Which event should I be using? as
On_Current colours all the records based on the 1st record values.
Do I have to force the form to move down each record individually and then
back to the top to apply the record level checks that I am after?

Tried Conditional Formatting but it doesn't appear to be usable for my
requirements.

Cheers,
Steve