Hi cherylsing:
Interesting problem. One solution would be to create two text boxes
and two transparent command buttons as follows:
Test Box 1
Name: tbxYesCheckBox
Height: 0.1688"
Width: 0.1688"
FontWeight: Bold
Label Caption: "Yes:"
Text Box 2
Name: tbxNoCheckBox
Height: 0.1688"
Width: 0.1688"
FontWeight: Bold
Label Caption: "No:"
Command Button 1
Name: cmdYesCheckBoxCover
Height: 0.1681"
Width: 0.1681"
Transparent = Yes
Command Button 2
Name: cmdNoCheckBoxCover
Height: 0.1681"
Width: 0.1681"
Transparent = Yes
Place the transparent command buttons directly over the little square
text boxes. This is will prevent the "I" cursor from parking in
the text box.
Put the following code in each of the transparent command button click
events:
If IsNull(Me!tbxYesCheckBox.Value) = True Then
Me!tbxYesCheckBox.Value = "X"
Me!tbxNoCheckBox.Value = Null
Else
Me!tbxYesCheckBox.Value = Null
Me!tbxNoCheckBox.Value = "X"
End If
This code should put an "X" in either the Yes or No text box check
box, but not both.
Hope this helps.
John