Formatting a textbox background

[jminn0311]

How can you format the background color of a textbox if a certain condition is met? Like a checkbox is checked true so the background of a textbox on the same form needs to be a certain color in that condition.

Thank you,

Jeff M.

 

[RoyVidar]

Check out the conditional formatting in the format menu (2000+ version). Use the "Expression is" in the first dropdown, enter your expression, format...

Roy-Vidar

 

[sophiet]

On the on current event of the form:
If Me.MyCheck = 0 Then
Me.MyText.BackColor = RGB(155, 155, 155)
Else
Me.MyText.BackColor = RGB(0, 0, 0)
End If