Make a boolean field on a form more intuitive

Access 2013.

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?
peispudAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Use a checkbox on a form. That will work with a Boolean.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
peispudAuthor Commented:
That works fine.  Thank you very much sir.
0
PatHartmanCommented:
I also prefer the checkbox but you can set the format so Boolean fields show as Yes/No or True/False.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.