Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / May 2005

Tip: Looking for answers? Try searching our database.

Dropdown Listbox

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
XMan - 26 May 2005 20:43 GMT
Is there a dropdown listbox control?
I see only either combobox or listbox.
TIA.
Bob Howard - 26 May 2005 21:29 GMT
That's called a combo box...
> Is there a dropdown listbox control?
> I see only either combobox or listbox.
> TIA.
Wayne Morgan - 26 May 2005 21:40 GMT
A combo box is frequently referred to as a dropdown listbox. Try it and see
if that is what you're after.

Signature

Wayne Morgan
MS Access MVP

> Is there a dropdown listbox control?
> I see only either combobox or listbox.
> TIA.
XMan - 26 May 2005 22:12 GMT
I don't want user to type in the box.
They can only drop the list and select.
Maybe there's a property that I'm missing.

> A combo box is frequently referred to as a dropdown listbox. Try it and see
> if that is what you're after.
>
> > Is there a dropdown listbox control?
> > I see only either combobox or listbox.
> > TIA.
Rick Brandt - 26 May 2005 22:24 GMT
> I don't want user to type in the box.
> They can only drop the list and select.
> Maybe there's a property that I'm missing.

Access has no such control.  You can size a ComboBox horizontally so that
all you see is the arrow but they will still be able to type in it (they
just won't be able to see what they're typing). LimitToList = Yes would
restrict them to typing only an entry that matches one of the choices in the
list though.

Signature

I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

Wayne Morgan - 26 May 2005 23:28 GMT
Rick's answer is the best, limit them to what is in the list but let them
type. You can prevent any typing though by using code. In the KeyDown event
of the combo box set KeyCode = 0. This will cancel their keyboard input.
However, this will cancel ALL of their keyboard input while the combo box
has the focus, including being able to press Esc to undo an unwanted change
to the combo box. You could use an If statement to allow certain keys, but
cancel the others.

Signature

Wayne Morgan
MS Access MVP

>I don't want user to type in the box.
> They can only drop the list and select.
[quoted text clipped - 7 lines]
>> > I see only either combobox or listbox.
>> > TIA.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.