changing the backcolor of a single record in MSAccess Form

[vb_wannabe]

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

[Helger]

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

[chrisjk]

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.

[ae_jester]

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.