Go Back   Access World Forums > Microsoft Access Discussion > General

Thread Tools Rate Thread Display Modes
Old 04-26-2018, 08:29 AM   #1
Newly Registered User
Join Date: Sep 2010
Posts: 384
Thanks: 69
Thanked 0 Times in 0 Posts
Learn2010 is on a distinguished road
Thumbs up Combo Box Select As You Type

I have a combo box on a form. In the gotFocus Event I have Combo1.Dropdown so that the user gets a list of 20 records when they enter the box and before they start typing. I can get the first matching record to come to the top as they type. For example, I type "sa" and get sac, sad, sag, etc.

Is there a way to have it highlight the first record when that happens?

Thank you.

Learn2010 is offline   Reply With Quote
Old 04-26-2018, 09:22 AM   #2
Pat Hartman
Super Moderator
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,488
Thanks: 13
Thanked 1,433 Times in 1,365 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Combo Box Select As You Type

NO. The first record is at the top of the list and should be obvious. Pressing tab completes the autofill if that is what you are after. Make sure that the RowSource is sorted by this text value or type ahead will not work correctly.
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
The Following User Says Thank You to Pat Hartman For This Useful Post:
Learn2010 (04-26-2018)

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Type mismatch when select by ComboBox GoAccess Forms 2 03-08-2018 04:57 AM
[SOLVED] Select record on Subform to select default value in combo box stmoong Forms 1 05-06-2014 08:01 PM
Select From Where, type mismatch... aaron2 Modules & VBA 3 08-03-2011 11:01 PM
How to Select a records as you type a name PNGBill General 10 06-03-2010 10:53 PM
[SOLVED] Multi-Select ListBoxes as Report/Query Criteria, Using a Combo Box to select a Range Tad71 Forms 1 09-24-2003 11:14 PM

All times are GMT -8. The time now is 03:05 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World