Change text colour

[kryten]

Hi everyone,

What code would I use to change the text colour of a text box when a checkbox is ticked?

I need to change the text colour to red to alert the user when they enter an item where the discontinued box is checked.

Thanks for any advice you can give.

 

[Agnostiker]

Something like this?

If Me.Discontinued_Box Then
   Me.TextBox_Name.ForeColor=RGB(255,0,0)
End If

Greetings from Berlin

Agnostiker