• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Autocomplete Textbox plus listbox

Autocomplete Textbox plus listbox

Autocomplete textbox and listbox in one. Gets data from a recordset then populate the listbox. Autofills the textbox then synchronously highlights the listbox. Great autocomplete please vote for ME.

Side Effects
NOTE: Applicable to 32k of entries in the database. Anything larger than that, it will crash because listbox can't hold more than 32k of data. Cheers!!!

API Declarations
Option Explicit
'API call to listbox
Private Declare Function SendMessage Lib "user32" Alias "SendMessageA" ( _
ByVal hwnd As Long, _
ByVal wMsg As Long, _
ByVal wParam As Long, _
ByRef lParam As Any _
) As Long
Const LB_FINDSTRING = &H18F

Rate Autocomplete Textbox plus listbox

• 1
• 2
• 3
• 4
• 5

(5(5 Vote))

Download Autocomplete Textbox plus listbox