How create a combobox which allows user to pick more than one valu

R

Ramtin

for one of the fields on my table, I want to create a listbox which gives the
vlaues for users to choose from, is it possible to choose more than one
vlaues ina comb or list box?
 
D

Douglas J. Steele

It's not possible with a combo box. With list boxes, there's a MultiSelect
property that you can set to either Simple (Multiple items are selected or
deselected by clicking them with the mouse or pressing the SPACEBAR.) or
Extended (Multiple items are selected by holding down SHIFT and clicking
them with the mouse or by holding down SHIFT and pressing an arrow key to
extend the selection from the previously selected item to the current item.
You can also select items by dragging with the mouse. Holding down CTRL and
clicking an item selects or deselects that item.)

Note, though, that you cannot bind a control to a multiselect list box: it's
only intended to be used unbound. In other words, if you're hoping that
users will be able to select multiple values and store them in a single
field in your table, you're going to be sadly disappointed. That's not how
relational databases are supposed to work, so Access doesn't allow it, at
least not in current versions (it's going to in Access 2007, but that's a
discussion for another day)

Instead, you need two tables: one to hold the main data, and one to hold the
additional data (what you want multi-selected).
 
J

Jeff Boyce

Ramtin

Your "subject" mentioned a combobox, but your description mentions a
listbox.

The "Multi-select" property only applies to listboxes.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
R

Ramtin

Yes I need to know how to create it

Jeff Boyce said:
Ramtin

Your "subject" mentioned a combobox, but your description mentions a
listbox.

The "Multi-select" property only applies to listboxes.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
D

Douglas J. Steele

Create it like normal, without worrying about multiselect.

Once you've created it, select the control and look at the properties. Find
the MultiSelect property, and change its value.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top