Combo dropdown (1 Viewer)

[kirkm]

My combo box is set to a Query with many results. When clicking to open the dropdown list I cannot easily scroll to the last entry.
Is there any way to make this happen?

 

[kirkm]

How many entries do you have?

 

[Gasman]

Use Ctrl + End

 

[Uncle Gizmo]

I have a product that might solve your problem. It's a pop-up form which captures your combo-box and allows you to search the Combo. You can obtain a free copy, contact me for details..

More information on my website here:-

Combo Box Alpha List - Nifty Access

Combo-box Alpha List Combo Box Alpha List (for MS Access) One of the problems you can run into when you have a combo-box which contains a lot of records, is it can be very difficult for the user to find a particular record. With the "Combo Box Alpha List" you…

www.niftyaccess.com

Direct Download Here:-

Nifty Combo Box Organiser - MS Access

One of the problems you can run into when you have a combo-box which contains a lot of records, is it can be difficult for the user to find a particular record. With the "Nifty Combo Box Organiser" you can offer your user a professional and sophisticated search function for your combo box.More...

gum.co

Combo-box Alpha List

Please make sure you watch the prerequisites video BELOW before downloading the product..

Combo Box Alpha Form Prerequisites - 1

 

[kirkm]

Control End is exactly what's needed, then scrolling is lightning speed.. beaut. But can this be done automatically anyhow?
Uncle Gizmo, thanks, will have a play. Record source is already sql.

 

[kirkm]

I'm the eternal optomist, This didn't quite work!

Private Sub cboSelect_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
Stop
SendKeys "CONTROL END"
End Sub

 

[Gasman]

Control End is exactly what's needed, then scrolling is lightning speed.. beaut. But can this be done automatically anyhow?
Uncle Gizmo, thanks, will have a play. Record source is already sql.

Well there is SendKeys, not something I have ever used and apparently not that reliable.

Application.SendKeys method (Excel)

Office VBA reference topic

docs.microsoft.com

You would need some way to indicate to use it or not though?, as I cannot see you want to go to the end everytime you entered the combo?
Perhaps a double click ?

 

[Gasman]

I'm the eternal optomist, This didn't quite work!

Private Sub cboSelect_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
Stop
SendKeys "CONTROL END"
End Sub

No, you cannot just make it up , look at the link I posted for Sendkeys

 

[Gasman]

This works now and again. I see why they say unreliable.
I've not had to use Sendkeys, so you will have to experiment further.

Private Sub cboTransactionDate_DblClick(Cancel As Integer)
SendKeys "{Down}", True
SendKeys "^{End}", True
End Sub

HTH