changing the backcolor of a single record in MSAccess Form

Does anyone know how to change the backcolor of a single record in a MSAccess Form?

If i use field.backcolor = 16777215 it changes the backcolor of ALL records :(


thanks

What kind of form do you use? I mean what kind of controls do you have on your form?

I think you'll have to use OnCurrent event to change the form's background colour depending on the record.

On Current is fired when you change records.

There is a way to do it using the "Format" property.....go to access help and type in format and you should get the information there.