Change Font color in a text box

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

color coding values 1
Plz Help! Create table when submit form 0
Access How to record date/time when specific field is modified in Access 2007 0
Change font color from a check box 1
Change the font color/background of a text box depending on value 6
Tech Support 2
Variable Font Color in Combo Box 1
Text box focus without font white on black 2

Top