Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Access vs auto-complete

Posted on 2008-10-27
Medium Priority
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 1000 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 1000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

It’s quite interesting for me as I worked with Excel using for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

722 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