Continuous Form- Record Backcolor Property

[kmarkus]

I am trying to use a continuous form to display my data.
Based on the value of the data in one of the fields, I
would like to change the background color on that
individual record. When I use the backcolor for the
textbox, it changes the backcolor for all of the
records. Is there a way to control the backcolor per
record?

 

[fredg]

I am trying to use a continuous form to display my data.
Based on the value of the data in one of the fields, I
would like to change the background color on that
individual record. When I use the backcolor for the
textbox, it changes the backcolor for all of the
records. Is there a way to control the backcolor per
record?

It depends upon your version of Access.
In Access 2000 and newer you can use a control's conditional
formatting property.

For some examples see:
http://www.lebans.com