Please can someone help me! I have a subform which contains multiple records. One of the fields in the records is called "Status" & the user will input one of three things in this field. These will be 'swapout', 'rts' or blank. I need each record to have a certain colour, depending on the data in the 'swapout' field. For example, if they enter 'swapout', the record will be yellow; if they enter 'rts' the record will be red & if it is blank, the record will be white. The problem I am having is that when i enter one of these three, not only does that record change colour, but ALL the records change to that colour. If anyone has any ideas @ all, I will be very very grateful.

97 or A2K?

A2K.

Maybe the on current event will help

If it is A2K, then check out Conditional Formatting with the field. You can find this on your main tool bar under Format. Here you can set up 3 different colours depending on the resulting status.

Good luck.

The conditional formatting was exactly what I was looking for. Thankyou so much Carol.