[RESOLVED] Access - Changing control property on one record but not all records

[salvelinus]

I couldn't get it to work for a continuous view (not saying it can't be done, just that I didn't get it), but did get it for Single record view. Code like this in the Form_Current event:

Private Sub Form_Current()
       If [txtFoo] = "B" Then
            [txtFoo].BackColor = vbBlue
      Else
            [txtFoo].BackColor = vbWhite
      End If
End Sub

You'd have to alter it some for a combobox, but that's the idea. If you have to have a continuous form, I don't know without more research.