Convert "yes/no" field text to "in/out"

[mapondera]

How can I set the text to be "in/out" using a "yes/no" field?

I know how to use the 'properties' function of a field in a table or query to convert a checkbox field to a textbox and display the words "yes/no" or "on/off."

 

[Jack Cowley]

My solution would be to use a check box and then use an unbound text box with code like this in the On Current event of the form:

Select Case CheckBoxField
Case -1
UnboundTextBox = "In"
Case 0
UnboundTextBox = "Out"
End Select

You can set the checkbox to Invisible if you like....