[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.

[RiceRocket]

Thanks again for the post, I really appreciate you trying to help me. Using single form is an option, but I really need continuous view. I'll keep trying and let you know if i figure something out.

[RiceRocket]

So I tried a version of your code, Salvelinus and it worked except that as soon as i clicked on a new record, the control's backcolor went back to the color it was before. I'm pretty sure that is because it was in the Form_Current event. Is there a way to save the properties of the control after they are changed in the Form_Current event procedure?

[salvelinus]

Ok, may have found what you want. Check here for conditional formatting.

[RiceRocket]

Perfect!! That was EXACTLY what I was looking for. Man, there is a wealth of info in that sample program. Thanks again for all your help, it has been much appreciated!

[RiceRocket]

I have a textbox that I use as the background for each of my records. Does anyone know how to completely disable the textbox control so that it can't be clicked and therefore in focus? I have the properties of the textbox set to .enabled = false and .locked = true, but I can still click on the textbox which then covers up all the other controls in the record. Anyone?