Good day to everybody!
I just want to know on is there any function/solution in vb6 that offers the best/most fastest way to autocomplete listview when type in a textbox.The data should be from SQL Server using ADO connection...Ive seen this function(I've not tested it yet) from
Private Sub Text1_Change() On Error GoTo ErrMsg Dim LstItm As ListItem Dim Strt as Integer ListView1.FindItem(Text1.Text, , , 1).Selected = True 'If something was chosen then we get the rest of it strt = Len(Text1.Text) Text1.Text = ListView1.SelectedItem.Text Text1.SelStart = strt Text1.SelLength = Len(Text1.Text) - strt Exit Sub ErrMsg: ListView1.SelectedItem.Selected = False End Sub
Anybody can help to make this the most fastest or is this the most fastest way of autocompleting? Im pulling a large data from SQL Server and will be filtered via autocomplete function then display it in a listview.
Thank you for helping!