Knucklehead,
Roy knows a lot more about Access than I do, but I just can not see any utility in that approach.
1. It can not be used on a continous form
2. Requires two controls
3. Has no "Click" utility
4. As posted it does not make sense
The post says to lock the control, but trap the After update event. I might be misreading it, but it just does not make sense to me.
If you want an X, this works fine.
=IIf([yourTrueFalseFieldGoesHere],"X","")
Private Sub txtBxMyCheck_Click()
Me.blnTF = Not Me.blnTF
End Sub
1. It can be used on a continous form
2. Requires one control
3. You can click it just like a checkbox
However, I was thinking continous form. On a single form there is a better way. Make a command button, and there is an Check Marrk image that you can put on the command button. Surround the cmd button by a rectangle and fill it in white. Ensure that you send the rectangle to the back, and the cmd button is in the front. Here is the code.
Private Sub Command10_Click()
Me.blnTF = Not Me.blnTF
Command10.Transparent = Not (Me.blnTF)
End Sub
1. Can not be used on a continous form
2. Has click capability
3. Provides a nice graphic check.
4. One control and simple code.