different colours for different records in a continuous form

[andy mac]

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.

 

[Rich]

97 or A2K?

 

[andy mac]

A2K.

 

[willem]

Maybe the on current event will help

 

[Carol]

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.

 

[andy mac]

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