I have a form which has a Boolean yes/no field. By default, the field is set to 'yes' but the user is free to change it value.
When the user enters the field (goes into edit mode), the cell will display
-1 or 0
for yes or no. The user input a zero or minus 1.
I would prefer that the user of the database to not see the Boolean equivalents. I really don't like combo boxes on a form. I realize that I could set this field to a text field with a length of 1 (allowing only 'y' or 'n'), but this would make some other things more difficult for me.
I like the Boolean field, but want it to be more elegant. Is there another solution?