Continuous Form BackColor issue

[ali32uk]

Hi

I would appreciate anyone's help with this

I have a continuous form which I m using the backcolor function to change a text box [Order_Frequency_100] color based on the value in another textbox [Rating100]

Code:
Private Sub Form_Current()

If Me.Rating100.Value < 4.5 Or IsNull(Me.Rating100.Value) Then
Me.Order_Frequency_100.BackColor = 238
ElseIf Me.Rating100.Value > 179.2 Then
Me.Order_Frequency_100.BackColor = 32768
Else
Me.Order_Frequency_100.BackColor = 42495
End If

End Sub

unfortunately it applies the same to all records on the continuous form, so for example it I click the first row, it changes all rows to show the same colors as the first row, what I d like is each row in the continuous form to represent colors for its own value for Rating_100

Anyone help me out? as this is a little beyond my abilities... (or maybe alot...)

Best regards

Ali

 

[MajP]

Unfortunately in a continuous form there is really only 1 set of controls and everything else is a "paint" of those controls. This can be done using conditional formatting. Google conditional formatting you will get a ton of examples. Here is one.

https://support.office.com/en-IN/ar...rmatting-6ba9e9fa-4347-4183-b335-44e43b05e22f