Auto Expand Drop Down Menu Box

[magmike]

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)

[Stuart McCall]

"magmike" <ma******@yahoo.comwrote in message
news:11*********************@k79g2000hse.googlegro ups.com...

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

[magmike]

On Sep 5, 12:03 pm, "Stuart McCall" <[e-mail]:

"magmike" <[e-mail] in message

news:11*********************@k79g2000hse.googlegro ups.com...

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!

[lgeastwood]

On Sep 5, 3:16 pm, magmike <[e-mail]:

On Sep 5, 12:03 pm, "Stuart McCall" <[e-mail]:

"magmike" <[e-mail] in message

news:11*********************@k79g2000hse.googlegro ups.com...

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

[magmike]

On Sep 5, 2:59 pm, [e-mail] wrote:

On Sep 5, 3:16 pm, magmike <[e-mail]:

On Sep 5, 12:03 pm, "Stuart McCall" <[e-mail]:

"magmike" <[e-mail] in message

>news:11*********************@k79g2000hse.googlegr oups.com...

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- Hide quoted text -

- Show quoted text -

Perfect! Thanks!