Results 1 to 10 of 10
  1. #1
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581

    yes/no box


    I'm curious if a yes/no box can be put on a form like combo box. I know about the toggle buttons. I was hoping that it was possible to make it look like a combo box.

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    comboboxes only display text, so you can change the control to a combo with the following settings

    rowsource: 0;No;-1;Yes
    type: Value List
    column count: 2
    column width: 0
    bound column: 1

  3. #3
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    When I go into the properties of the yes/no box, I don't see any of those

  4. #4
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    change the control to a combo

  5. #5
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    Looks like I'm going to pass on this. I don't even know how to change the yes/no to a combo. Couldn't find a way in the table. I tried the form, couldn't find how to do it in the properties.

  6. #6
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    in a table (not recommended because it hides the true values)
    a) in design view, click on the Lookup tab for the yes/no field you want to change
    b) in display control select Combo Box
    c) populate properties as above

    for a form
    a) in design view delete your current checkbox control, if you have one
    b) drag a combo control onto a form
    c) populate properties as above, plus set the combo controlsource to the name of your yes/no field

  7. #7
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    That was amazing. Thanks. Now, is there a way to change yes/no to something else?

  8. #8
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    The combo box says yes/no, or true false. There is a drop down in the properties to put the words there. Is there a way to change the "yes/no" to different options?

  9. #9
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    the yes/no, true/false is a formatting property. you can change the rowsource

    rowsource: 0;Elephants;-1;Lions

    whatever you want

  10. #10
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    Thanks. That was great.

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums