Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How Do I create a drop-down box that allows multiple selections to

Discussion in 'Information Technology' started by Flojoe, Jul 28, 2006.

  1. Flojoe

    Flojoe
    Expand Collapse
    Guest

    I created a profile where people can add their name contact number and select
    from a drop-down menu 1 skill item. However, if they want to select more
    than 1 item from the skill drop-down menu how do I make that available to
    them? Thanks!
     
  2. Loading...


  3. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "Flojoe" wrote

    > I created a profile where people can add
    > their name contact number and select
    > from a drop-down menu 1 skill item. However,
    > if they want to select more than 1 item from
    > the skill drop-down menu how do I make
    > that available to them? Thanks!


    The ComboBox (which is the Access control with drop-down capability) does
    not support multiple selections. The List Box has a Multi-Select Option, but
    does not natively have a drop-down capability. One way you could do this is
    to use a Text Box behind the ListBox, set the List Box's Visible Property to
    No, and in the Text Box's GotFocus event, just set the List Box's Visible
    Property to True.

    Then, of course, you might have to decide under what conditions you want
    that List Box to return to invisibility.

    Simplest way, of course, is to give up some screen real estate and just use
    a ListBox, which always shows multiple rows.

    Larry Linson
    Microsoft Access MVP
     

Share This Page