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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

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 …
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor ( Top Charts is a view in which you can set seve…

630 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