Incremental searches within list boxes

The DBList and DBCombo controls expose a MatchEntry property, that – when set to True – permits to perform quick incremental searches by simply typing the searched sequence of characters. If MatchEntry is set to False, any time the user presses a key, the next item that begins with that character becomes the highlighted item.Unfortunately this feature has not been added to standard unbound list box and combo box controls, and we have to implement it using two separate controls, a text box and a listbox, and a lot of code. The principle is simple: when the search string typed in the text box changes, a fast search is performed on the list box (using the LB_FINDSTRING message).

Private Declare Function SendMessage Lib "User32" Alias "SendMessageA" (ByVal _    hWnd As Long, ByVal msg As Long, ByVal wParam As Long, _    lParam As Any) As LongConst LB_FINDSTRING = &H18F' this is a form-level variableDim DoSearch As IntegerSub List1_Click()    ' user selected a new item    ' (also activated by Text1_KeyDown)    Text1.text = List1.textEnd SubSub List1_MouseDown(Button As Integer, Shift As Integer, X As Single, _    Y As Single)    ' keep the two controls synchronized    Text1.text = List1.textEnd SubSub List1_MouseMove(Button As Integer, Shift As Integer, X As Single, _    Y As Single)    ' keep the two controls synchronized    Text1.text = List1.textEnd SubSub Text1_Change()    Static active As Boolean    Dim index As Integer    Dim search As String    Dim found As Integer    ' avoid recursive calls    If active Or DoSearch = False Then Exit Sub    active = True    ' search is not case sensitive    search = UCase$(Text1.text)    found = -1        ' search the first item in the listbox    ' that matches the search string in the textbox    found = SendMessage(List1.hWnd, LB_FINDSTRING, -1, ByVal search)    If found >= 0 Then        ' make the found value the current item        List1.ListIndex = found        Text1.text = List1        ' select the remaining characters        Text1.SelStart = Len(search)        Text1.SelLength = 999    End If    active = FalseEnd SubSub Text1_KeyDown(KeyCode As Integer, Shift As Integer)    If Shift Then        ' do nothing if a shift key is pressed    ElseIf KeyCode = vbKeyUp Then        ' move on previous item        If List1.ListIndex > 0 Then            List1.ListIndex = List1.ListIndex - 1        End If        KeyCode = 0    ElseIf KeyCode = vbKeyDown Then        ' move on next item        If List1.ListIndex < List1.ListCount - 1 Then            List1.ListIndex = List1.ListIndex + 1        End If        KeyCode = 0    End IfEnd SubSub Text1_KeyPress(KeyAscii As Integer)    If KeyAscii = 8 And Text1.SelStart > 0 Then        ' if BackSpace has be pressed, trim one        ' character off the search string        DoSearch = False        Text1.text = Left$(Text1.text, Text1.SelStart)        Text1.SelStart = Len(Text1.text)    Else        DoSearch = True    End IfEnd Sub

When a match is found, the selection is moved on the corresponding item and it also appears in the text box editing area, with the remaining characters already selected (so that they can be easily overwritten by another key press).

Share the Post:
Share on facebook
Share on twitter
Share on linkedin


The Latest

homes in the real estate industry

Exploring the Latest Tech Trends Impacting the Real Estate Industry

The real estate industry is changing thanks to the newest technological advancements. These new developments — from blockchain and AI to virtual reality and 3D printing — are poised to change how we buy and sell homes. Real estate brokers, buyers, sellers, wholesale real estate professionals, fix and flippers, and beyond may

man on floor with data

DevX Quick Guide to Data Ingestion

One of the biggest trends of the 21st century is the massive surge in internet usage. With major innovations such as smart technology, social media, and online shopping sites, the internet has become an essential part of everyday life for a large portion of the population. Due to this internet

payment via phone

7 Ways Technology Has Changed Traditional Payments

In today’s digital world, technology has changed how we make payments. From contactless cards to mobile wallets, it’s now easier to pay for goods and services without carrying cash or using a checkbook. This article will look at seven of the most significant ways technology has transformed traditional payment methods.