Access VBA listbox value while still typing
Posted on 2012-08-19
I have a form with a bound listbox, with only one column - a string field of job numbers.
While the user types I want to check whether there is no match, and give a message along the lines of "There is no match for this job."
For a text box I would have to use txtField.text on a key press event, as txtField.value does not yet have what has been typed.
For the listbox, the keypress event is being triggered, but cboList.text is still empty after typing my first character.
What should I use to find the value of the listbox so far, on each key press?