5,692,513 members and growing! (15,669 online)
Email Password   helpLost your password?
Languages » C / C++ Language » General     Intermediate

AutoComplete ComboBox in VB.Net

By Daryl

2 Simple Functions to call from ComboBox events to Autocomplete. Will work with Data Bound combos.
VB, Windows, .NET 1.0, .NET, Visual Studio, Dev

Posted: 21 Apr 2002
Updated: 7 May 2002
Views: 253,516
Bookmarked: 92 times
Announcements
Loading...



Search    
Advanced Search
Sitemap
52 votes for this Article.
Popularity: 7.43 Rating: 4.33 out of 5
1 vote, 2.4%
1
0 votes, 0.0%
2
3 votes, 7.3%
3
11 votes, 26.8%
4
26 votes, 63.4%
5

Introduction

This is an AutoCompleting ComboBox that works with Data Bound or Regular ComboBoxes in VB.NET. As you type the case is preserved but the remaining text is auto filled by the list items. When the Leave function is called the case is fixed and the index from the list is also selected if there is a matching item.

Sample Image - AutoComplete_ComboBox.gif

Call the corresponding functions from your Combobox's KeyUp and Leave events like so:

Private Sub cboName_Leave(ByVal sender As Object, ByVal e As System.EventArgs) 
                                                            Handles cboName.Leave
    Dim recRowView As DataRowView
    Dim recName As DB.tblNameRow

    AutoCompleteCombo_Leave(cboName)

    'OPTIONAL: Now you can  do some extra handling if you want


    'Get the Selected Record from my Data Bound Combo (Return Type is DataRowView)

    recRowView = cboName.SelectedItem
    If recRowView Is Nothing Then Exit Sub

    'Display the Name Info (Row Type comes from my bound Dataset)

    recName = recRowView.Row
    lblAccountNum.Text = recName.AccountNum
    lblCompanyName.Text = recName.CompanyName

End Sub

Private Sub cboName_KeyUp(ByVal sender As Object, 
              ByVal e As System.Windows.Forms.KeyEventArgs) Handles cboName.KeyUp

    AutoCompleteCombo_KeyUp(cboName, e)

End Sub

Here are the Generic Functions for handling the events:

Public Sub AutoCompleteCombo_KeyUp(ByVal cbo As ComboBox, ByVal e As KeyEventArgs)
    Dim sTypedText As String
    Dim iFoundIndex As Integer
    Dim oFoundItem As Object
    Dim sFoundText As String
    Dim sAppendText As String

    'Allow select keys without Autocompleting

    Select Case e.KeyCode
        Case Keys.Back, Keys.Left, Keys.Right, Keys.Up, Keys.Delete, Keys.Down
            Return
    End Select

    'Get the Typed Text and Find it in the list

    sTypedText = cbo.Text
    iFoundIndex = cbo.FindString(sTypedText)

    'If we found the Typed Text in the list then Autocomplete

    If iFoundIndex >= 0 Then

        'Get the Item from the list (Return Type depends if Datasource was bound 

        ' or List Created)

        oFoundItem = cbo.Items(iFoundIndex)

        'Use the ListControl.GetItemText to resolve the Name in case the Combo 

        ' was Data bound

        sFoundText = cbo.GetItemText(oFoundItem)

        'Append then found text to the typed text to preserve case

        sAppendText = sFoundText.Substring(sTypedText.Length)
        cbo.Text = sTypedText & sAppendText

        'Select the Appended Text

        cbo.SelectionStart = sTypedText.Length
        cbo.SelectionLength = sAppendText.Length

    End If

End Sub


Public Sub AutoCompleteCombo_Leave(ByVal cbo As ComboBox)
    Dim iFoundIndex As Integer

    iFoundIndex = cbo.FindStringExact(cbo.Text)

    cbo.SelectedIndex = iFoundIndex

End Sub

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

About the Author

Daryl



Occupation: Web Developer
Location: United States United States

Other popular C / C++ Language articles:

Article Top
Sign Up to vote for this article
You must Sign In to use this message board.
FAQ FAQ Noise ToleranceSearch Search Messages 
 Layout  Per page   
 Msgs 1 to 25 of 55 (Total in Forum: 55) (Refresh)FirstPrevNext
GeneralAutocomplete Questionmembermchlcmprch14:29 29 Oct '07  
GeneralAutocomplete suggestion must try..memberSamee Dars23:44 16 Mar '08  
GeneralRe: Autocomplete suggestionmemberSamee Dars23:58 16 Mar '08  
Generalthankmemberansing4:31 20 Jan '07  
Generalthankmemberansing4:30 20 Jan '07  
QuestionDroppedDownmemberandrewf2212:16 11 Jan '07  
AnswerRe: DroppedDownmemberpaulmcl4:17 26 Jan '07  
GeneralA little different codememberrtodosic8:15 31 Mar '06  
Generalonly works when I type slowlymembermiko_tnt6:20 21 Nov '05  
GeneralWhat is DB.tblNameRow?membersanders.tec8:53 16 Sep '05  
Generalneeds improvementmembereletters_my20:48 30 Jan '05  
Generalautofill only works when I type slowsussRobert Gray15:59 20 Jun '04  
GeneralRe: autofill only works when I type slowmemberJoseph Hicks13:27 27 Jan '05  
GeneralRe: autofill only works when I type slowmemberTunca Bergmen4:07 3 Feb '05  
GeneralRe: autofill only works when I type slowsussAnonymous7:19 14 Apr '05  
GeneralSave Combo Boxmemberukjock8:34 1 Jan '04  
GeneralRe: Save Combo BoxmemberdELm16:22 5 Feb '04  
GeneralRe: Save Combo Boxsussaniepras8:24 30 Dec '04  
GeneralEscapesussAnonymous18:48 15 Oct '03  
GeneralDB.tblnameRowmembervb_me16:51 10 Sep '03  
GeneralJust One SubmemberLaurent Muller4:41 11 Aug '03  
GeneralRe: Just One SubmemberBehram14:29 9 Sep '03  
GeneralRe: Just One SubmemberLaurent Muller0:02 10 Sep '03  
GeneralRe: Just One SubsussAnonymous7:32 22 Nov '03  
GeneralRe: Just One Sub, slight change,memberkoo910:44 3 Dec '03  

General General    News News    Question Question    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

PermaLink | Privacy | Terms of Use
Last Updated: 7 May 2002
Editor: Chris Maunder
Copyright 2002 by Daryl
Everything else Copyright © CodeProject, 1999-2008
Web13 | Advertise on the Code Project