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

#1 (**permalink**) 28-Jul-2006, 08:34 AM

I created a profile where people can add their name contact number and select
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13104-how-do-i-create-drop-down.html
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 (**permalink**) 28-Jul-2006, 08:34 AM

"Flojoe" wrote

> I created a profile where people can add
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13104
> their name contact number and select
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13104
> 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