Change Font color in a text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How would I go by changing a font color from Black to Green after the number
has been updated?

Now I have a Button on the Form and a text box where the number is.

When some one changes the number and hits the submit button I would like the
font to change to green.

Thank you
 
On the after update event of the field you can write the code that cmpare the
field value to the original value

Private Sub FieldName_AfterUpdate()
If Me.FieldName.OldValue <> Me.FieldName.Value Then
Me.FieldName.ForeColor = 4259584
Else
Me.FieldName.ForeColor = 0
End If

End Sub
 
Back
Top