Re: Auto Expand Drop Down Menu Box

On Sep 5, 3:16 pm, magmike <magmi...@xxxxxxxxx> wrote:
On Sep 5, 12:03 pm, "Stuart McCall" <smcc...@xxxxxxxxxxxxxxx> wrote:



"magmike" <magmi...@xxxxxxxxx> wrote in message

news:1189001988.779078.87330@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

I've got a control on my form that allows the user to select a record
based on a form field (in this example, the drop down menu shows the
company name, followed by the contact name but uses the contactid to
change the data on the form). Most users, start typing the company
name which will auto complete itself with the first entry with the
letters typed so far. They can then click on the arrow to view the
listings, select the one they want and the form changes.

However, I have a bunch of mini-me's in the office, that like to do
everything by keyboard if possible. So they are using ALT+Down Arrow
to expand the list. Is it possible to code the control to auto expand
when entered, preferrable not till the first letter is typed?

Thanks a bunch!

mike
(Dim mike=novice coder)

Lets say your combo is called Combo1. You need an OnEnter event proc that
looks like:

Private Sub Combo1_Enter()
Me.Combo1.Dropdown
End Sub- Hide quoted text -

- Show quoted text -

I put this in the OnChange property, which waits to pop it up until
typing takes place, which is what I wanted. That works great when
using all keyboard, but when someone uses the mouse to click on their
selection, the combo box pops it back up after clicking. Is there a
way to use the OnChange property so it stays put until the keyboarders
start typing but that it wont stay up when someone uses their mouse to
click on a selection?

(NOTE - the keyboarders are typing until they get to their desired
record, then hitting the ENTER button)

Thanks!

Try this

Private Sub Combo1_KeyPress(KeyAscii As Integer)
If Len(Me.Combo1.Text) = 0 Then
Me.Combo1.Dropdown
End If
End Sub

.

Relevant Pages

  • Re: Socialism is so gay.
    ... In my typing class in the late 70's, it was a largely co-ed class ... expensive)did not use a standard keyboard for data entry. ... Nearly all computer languages I use today are not case sensitive either. ... I use C or C++ on ARM chips, M68K chips, Intel X86 ...
    (soc.men)
  • Re: Socialism is so gay.
    ... In my typing class in the late 70's, it was a largely co-ed class ... expensive)did not use a standard keyboard for data entry. ... Nearly all computer languages I use today are not case sensitive either. ... I use C or C++ on ARM chips, M68K chips, Intel X86 ...
    (soc.men)
  • Re: Auto Expand Drop Down Menu Box
    ... everything by keyboard if possible. ... Is it possible to code the control to auto expand ... typing takes place, ... selection, the combo box pops it back up after clicking. ...
    (comp.databases.ms-access)
  • Re: Auto Expand Drop Down Menu Box
    ... everything by keyboard if possible. ... I put this in the OnChange property, which waits to pop it up until ... typing takes place, ... selection, the combo box pops it back up after clicking. ...
    (comp.databases.ms-access)
  • Re: Exporting PM7 file to something useful on OS9?
    ... Let me tell you about this typing course. ... The typing course had exercises produced by one of the other teachers - ... Apple keyboard on my leg whilst supporting the LHS with my left hand. ...
    (uk.comp.sys.mac)