Colouring individual fields in a multiple row form

[Ace9x]

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

 

[Ace9x]

Sorted it out - error in conditional formatting expression was causing the
problem.

 

[Ofer]

Check help on Conditional Formating

Open the Form in design view, select the fieldyou want to format, from the
menu bar select Format > Conditional Formating

Select the color, the condition , and when you want to compare to another
field, write
[Field name]