Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-26-2018, 08:29 AM   #1
Learn2010
Newly Registered User
 
Join Date: Sep 2010
Posts: 373
Thanks: 65
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,246
Thanks: 13
Thanked 1,381 Times in 1,316 Posts
Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light
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)
Reply

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 05:01 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


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