Problem with Textbox Value

[ironbutterfly]

Hi, I'm very new to access. I have a form called Items. There's a checkbox called Check97 that if checked, produces a textbox called TextboxFixedWeightAmount.
When I am using the form in form view, it lets me enter a value into the textbox but as soon as I click out of that textbox, the contents of the textbox turns to "True" and only changes back if I click inside the box.

This is the code:

Private Sub Check97_Click()


If Me.Check97 = -1 Then
Me.TextboxFixedWeightAmount.Visible = True
Else
Me.TextboxFixedWeightAmount.Visible = False
Me.TextboxFixedWeightAmount.Value = Null
End If
End Sub


What do I need to change? Thanks for your help!

[John_G]

Is the textbox bound to a table field? If so, what is the data type of the field? It sounds as if it is perhaps bound to a Yes/No table field.

John

[ironbutterfly]

You're right...It was bound to True/False. I changed it to General Number and now it's perfect. Thank you.