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 / New Users / June 2006

Tip: Looking for answers? Try searching our database.

Using Keyboard Up and Down Arrows with Combo Boxes

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jack G - 27 Jun 2006 12:31 GMT
In most Windows Applications with combobox-like dialogs, you can start
typing in the box and after a few letters use the keyboard up and down
arrows to select the specific entry you want from the list.  With my Access
(2003) combo boxes, I have to reach for the mouse and hit the down arrow on
the combo box to display the list.  Is there a setting or property I could
change to get the behavior that would let me keep my hands on the keyboard?

Thanks for any help.

Jack
Arvin Meyer [MVP] - 27 Jun 2006 12:52 GMT
Try using the dropdown method:

Sub cboWhatever_GotFocus()
Me.cboWhatever.Dropdown
End Sub
Signature

Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

> In most Windows Applications with combobox-like dialogs, you can start
> typing in the box and after a few letters use the keyboard up and down
[quoted text clipped - 7 lines]
>
> Jack
Jack G - 27 Jun 2006 16:44 GMT
Arvin,

That's almost what I'm looking for, except I'd prefer it if the list would
not drop down until I strike the arrow key.  But if I can't find a way to do
that, this should work for me, too.  Thanks for the help.

Jack

> Try using the dropdown method:
>
[quoted text clipped - 12 lines]
>>
>> Jack
John Spencer - 27 Jun 2006 20:08 GMT
The keystroke to make the combobox drop down when it has the focus is
 Alt-key plus the Down Arrow key

> Arvin,
>
[quoted text clipped - 20 lines]
>>>
>>> Jack
Ken Snell (MVP) - 27 Jun 2006 12:58 GMT
I have a sample database that combines spin arrows with a combo box so that
you can navigate a combo box's list without dropping down the list:

http://www.cadellsoftware.org/SampleDBs.htm#Cbospin

Signature

       Ken Snell
<MS ACCESS MVP>

> In most Windows Applications with combobox-like dialogs, you can start
> typing in the box and after a few letters use the keyboard up and down
[quoted text clipped - 7 lines]
>
> Jack
Jack G - 27 Jun 2006 16:48 GMT
Ken,

Thanks for the reply.  But when I click on ' cboSpin 2002.zip' I only get a
little icon, no zip file.  I'm not sure if it's a problem with my Outlook or
if it can't find the file.

Jack

>I have a sample database that combines spin arrows with a combo box so that
>you can navigate a combo box's list without dropping down the list:
[quoted text clipped - 12 lines]
>>
>> Jack
Ken Snell (MVP) - 27 Jun 2006 22:12 GMT
You should get the option of opening or saving the zip file when you click
on the cboSpin 2002.zip hyperlink. Save the file to your hard drive, then
you can unzip it.

Signature

       Ken Snell
<MS ACCESS MVP>

> Ken,
>
[quoted text clipped - 20 lines]
>>>
>>> Jack
fredg - 27 Jun 2006 16:50 GMT
> In most Windows Applications with combobox-like dialogs, you can start
> typing in the box and after a few letters use the keyboard up and down
[quoted text clipped - 6 lines]
>
> Jack

Code the Combo box Enter event:
Me![ComboName].Dropdown

The box will drop-down as soon as you enter it. You can type the first
few characters and then use the arrow keys as needed.
Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Mike Revis - 28 Jun 2006 01:14 GMT
In addition to all the other correct responses. I usually just use the F4
key to make the box drop.

Mike

> In most Windows Applications with combobox-like dialogs, you can start
> typing in the box and after a few letters use the keyboard up and down
[quoted text clipped - 6 lines]
>
> Jack
Jack G - 29 Jun 2006 17:20 GMT
Thanks to all for the great feedback.  I've decided that what will work best
in my project is to use the Dropdown method with the OnDirty event. That way
when I'm just tabbing through the fields, nothing distracting happens, but
if I start to edit, the dropdown appears.

Jack

> In most Windows Applications with combobox-like dialogs, you can start
> typing in the box and after a few letters use the keyboard up and down
[quoted text clipped - 7 lines]
>
> Jack
 
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.