Colouring individual fields in a multiple row form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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]
 
Back
Top