Solved

Make a boolean field on a form more intuitive

Posted on 2014-11-05
3
281 Views
Last Modified: 2014-11-05
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?
0
Comment
Question by:peispud
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40425111
Use a checkbox on a form. That will work with a Boolean.
0
 

Author Closing Comment

by:peispud
ID: 40425168
That works fine.  Thank you very much sir.
0
 
LVL 38

Expert Comment

by:PatHartman
ID: 40425171
I also prefer the checkbox but you can set the format so Boolean fields show as Yes/No or True/False.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question