Access vs auto-complete

Posted on 2008-10-27
Last Modified: 2012-05-05
In access when Im typing something into a drop-down box, it tries to auto-complete the rest of the box, but in it doesnt, and I cannot find anything to switch it on.

From what I can see I think they are using the same component, but cant find out how to switch on auto-complete, or how to add it in code.

Any ideas?
Question by:tonelm54
  • 2
LVL 44

Expert Comment

ID: 22817581
Autocomplete is a feature built into the Access DropDown control - that is not the same control which is used in VB.NET.  The VB.NET DropDownList control does not support AutoComplete.

The two components LOOK the same, but they are no the same control.

Do you think you could try to build your own - The TextBox control does support AutoComplete (at least with VB 2008), and a DropDown list is composed of a TextBox control, a Button, and a ListBox.

check out:


LVL 44

Accepted Solution

Arthur_Wood earned 250 total points
ID: 22817749
I just discovered that the ComboBox control in VB.NET 2008 DOES support AutoComplete.  There are three AutoComplete related properties on the ComboBox control.

Maybe you might want to consider moving up to VB.NET 2008???

LVL 48

Assisted Solution

jpaulino earned 250 total points
ID: 22818341
>> I just discovered that the ComboBox control in VB.NET 2008 DOES support AutoComplete.  There are three AutoComplete related properties on the ComboBox control.

Also VS2005 supports!
You can do something like this:

        With Me.ComboBox1

            .AutoCompleteMode = AutoCompleteMode.Suggest

            .AutoCompleteSource = AutoCompleteSource.ListItems

            .DropDownStyle = ComboBoxStyle.DropDown

        End With

Open in new window


Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Open form in the top right hand corner of screen 5 36
Showdialog 8 29
VB.Net Serial COM1 Port - how to send this text via Serial COM port? 13 41 2010 11 24
Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String ( Literal, only instead of starting and ending with w…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now