Iphone

Question: My understanding is that a list box allows multiple selections but a combo box allows just one selection. For reasons of space I want a list box that has drop-down functionality. The Access 2002 help refers to 'Create a list box, combo box, or drop-down list box' and I assume a drop-down list box is what I need. The instructions are:

3. Click the List Box tool [icon1], the Combo Box tool [icon2], or the Dropdown List tool [icon3] in the toolbox.

I can't see any difference between icon 2 and icon 3, they both look like the Combo Box tool. However, if I use the Combo Box tool I can't find any way to set it up as a drop-down list box (ie, a drop-down that allows the user to click, highlight and accept more than one entry in the drop-down section).

I wonder if Microsoft are using combo box and drop-down list to mean the same thing - a single-select combo box. If so, is there another way to space-save on a form with a list box yet display all the possible selections when required by the user without the need to scroll?

[PS - I know a little vba so could probably cope with a programmatic solution].

Iphone

What is the functional purpose for your multi-selection? I hope you are not trying to store multiple values in a single field :-) If you are using this for filtering data on a form or a report there are a couple of approaches you could use to save space ... pop a seperate form with just the multi-select listbox when they click a button ... I have a report riteria builder ... most of the time I only need to run reports where I own a task record in our application but sometimes my boss likes to run reports on everyone in our group ... what I did in builtind the UI is to make a combobox for when people only need to make 1 selection and put a little button with the ... on it just to the right of the combobox and trained everyone that they need to click the button to make *multiple* selections for that particular field. When they click that button a simple form pops up (modal) with a multi-select listboxn and I return the results of their selection back to the main form in the Close event of the multi-select form. I am working on another project where they tend to make many multiple selections and while I have a bit of space they need multiple, multiple selection fields :-) On this project I used subforms bound to temp tables displayed in datasheet and made the data entery control inside the datasheet be a combobox ... this way they get auto-complete and the *entered* list grows and adds the scrollbar automagically because it is a datasheet. Of the two options the first one is more space conservative but the users really like the second one.