After update combobox question

[dealwi8me]

Hello,

I have the following lines of code:

If Len(cbo.Column(13)) > 0 Then
 If Suburb.Column(13) = -1 Then
   Me.Suburb.BackColor = 255
 End If
End If

When column(13) becomes -1 in one record i want the combobox sururb of that record to become red but with the above code i get all records red.

Any suggestions what am i doing wrong?

 

[RuralGuy]

It sounds like you have a Continuous form. Try using Conditional Formatting instead.

 

[dealwi8me]

How can i use conditional formatting in a combobox and have the condition in column(13)?

Condition1: Sururb.Column(13) equal to -1

Thank you for answering!

 

[RuralGuy]

TRy using the "Expression Is" format.

 

[dealwi8me]

Thank you... i will try it!