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
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 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

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

Suggested Solutions

Title # Comments Views Activity
Data organization issue 7 56
how to remove error in database 6 55
Import a excel sheet in a grid 2 45 code 9 28
This article explains how to create and use a custom WaterMark textbox class.  The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.   IMAGE OF WATERMARKS STEPS Create VB …
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 …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

734 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