I dont know how to code this simple...

[JTQ911]

I need to conditional format in 97. I searched some old threads and even downloaded Ken's sample database to see how it works but I dont know VBA enough to make it work on mine.

I have a form with a bunch of specs. For example, one field has a number that needs to be between 100 and 200. I want to have a check box next to this field that checks the box if its outside these values. Its probably really easy, but I cant get it to work. Thanks in advance!

Jim

 

[missinglinq]

Private Sub TextBox_AfterUpdate()
  If Me.TextBox < 100 Or Me.TextBox > 200 Then
    Me.CheckBox = -1
  Else
    Me.CheckBox = 0
  End If
End Sub