Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    May 2002
    Location
    Patagonia Region Chile
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Very long List Box accomadation (A2k)

    (Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

    Hello.

    Using techniques shown at http://allenbrowne.com/ser-50.html I have a mult-select listbox that passes selected values to the query for a report.

    My issue is that the listbox is SOOOOO long that users have to scroll up and down too far.

    Is it possible to have the list box spill over horizontally sort of like the START >PROGRAMS list does (in windows XP at least). or some other trick.

    Thanks

    Jason

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Very long List Box accomadation (A2k)

    Although a list box can have multiple columns, they are used to display different fields, not to accommodate very long lists.

    You could break the selection process into steps, along the lines of How to Synchronize Two Combo Boxes on a Form. The technique described there works for list boxes too.

  3. #3
    Star Lounger
    Join Date
    May 2002
    Location
    Patagonia Region Chile
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Very long List Box accomadation (A2k)

    Thank Hans.

    If I were to create say 4 list boxes. Each to display 25 items.
    How could I tweak the list box row source property to do that
    and
    How could the allenbrowne code be tweaked to pass any and all values selected in any and all of the textboxes to the report query?

    Thanks.

    Jason

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Very long List Box accomadation (A2k)

    I wouldn't do it like that, it's bad interface design.

    If you've got about 100 items, that's not too bad - users should be able to select items from a single list box. I thought you were dealing with many thousands of items.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •