Discussion on:

Message 18 of 54
0 Votes
+ -
Try this
bbuchert,

It seems that you may be looking at the wrong thing. Here is a little sample that shows a textbox on a form to display the value displayed by the checkbox:

Private Sub Form_Current()

If Me.chk1.Value = 0 Then
Me!txtCheckBoxStatus = "The value displayed by the checkbox is 'False'."
ElseIf Me.chk1.Value = -1 Then
Me!txtCheckBoxStatus = "The value displayed by the checkbox is 'True'."
End If

End Sub

Of course, the checkbox is bound to a Yes/No data type field in the forms's record source
If you test for the value of the checkbox then you should be OK.

I hope this helps --
Posted by jstribling@...
17th Feb 2008