Need help writing simple VBA script

[Minuet]

I am unfamiliar with VBA but need a simple script for my Access form. If my field "C_Type" = "04," then I would like the text in my "Name" field to be striked through (if possible), or red in colour instead of black. Could someone tell me how to write this? Thanks in advance!

 

[dwlerwill]

Try this code to change colour to red


C_Type.SetFocus

If C_Type.Text = "4" Then
Name.ForeColor = vbRed

Else:
End If


Not sure how you can set it to Strike Though the field though David Lerwill
"If at first you don't succeed go to the pub"

 

[Minuet]

Thanks for the code. I can't seem to make it work, though. What event do I use with the code? I have tried AfterUpdate, Change, Exit, and a few others. I don't know if it makes a difference, but I have Access 97.

 

[dwlerwill]

Use it on Lost Focus on the test box would be the best idea David Lerwill
"If at first you don't succeed go to the pub"