MS Access

[5bhaya]

I have a listbox that has two columns: EmployeeID and FullName (which is an employee full name). I have a textbox and what I would like to accomplish is that when a user types a letter in the textbox, the item in the list box (EmployeeID is a boundcolumn for the listbox )should be highlighted based on this input in the textbox. I have a code in the keypress_event of the textbox which passses on the letter typed to the procedure. The idea is to compare this string to each name in the listbox in a loop and if both strings are equal, to highlight the item in a listbox. The problem is I cannot find a property in the listbox that could give me the employee name (e.g. combo box has a list property)in iteration. Any idea/help shall be appreciated.

 

[jebry]

Hi!

In the textbox's change event you can use the following code:

Dim intRow As Integer

For intRow = 0 To Me!YourListBox.ListCount - 1
If Me!YourListBox.Columns(1, intRow) Like Me!YourTextBox.Text & "*" Then
Me!YourListBox.Selected(intRow) = True
Exit For
End If
Next intRow

hth
Jeff Bridgham
bridgham@purdue.edu

 

[5bhaya]

Thanks! It worked great. While it highlighted the name in
the list box still I had to select the highlighted item and thereafter click the button to view the selected name's detail form. So I reviewed Q218621 from Microsoft Knowledge base article and it served the purpose.