Listbox and multi-select and dropdown?

[Guest]

I need to have combo box capability with multi-select ability. I tried using
listboxes, but the problem I have is they don't drop down so I can see only
one listed item at a time. I cannot make the listboxes bigger. Is there any
way to code a listbox to drop-down, maybe by manipulating the height
property? If I could get the selected items to move to the top of the list it
would be great also. Has anyone done this? I hate to re-invent the wheel.
Thanks.

 

[OldPro]

I need to have combo box capability with multi-select ability. I tried using
listboxes, but the problem I have is they don't drop down so I can see only
one listed item at a time. I cannot make the listboxes bigger. Is there any
way to code a listbox to drop-down, maybe by manipulating the height
property? If I could get the selected items to move to the top of the list it
would be great also. Has anyone done this? I hate to re-invent the wheel.
Thanks.

Put a little command button next to a textbox, and use Windows Paint
to create a down arrow. Use the textboxes keydown event and/or the
down arrow to make the listbox appear with the appropriate recordset.
Turn the listbox invisible when the keydown event encounters an
<Enter>. Don't forget to bring the listbox to the forefront in the z
order while in design view, and to turn it invisible.