?
Solved

Make a boolean field on a form more intuitive

Posted on 2014-11-05
3
Medium Priority
?
284 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 2000 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
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…
Suggested Courses

765 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