I love the "search as you type" form Richard taught in Access Developer 8, Lesson 3. It works perfectly. EXCEPT, it does not accept a space bar input, so I cannot search for phrases, only single words. Is there a simple adjustment to the code I can implement to resolve this?
David SylvesterOP
@Reply 4 years ago
An example of the code:
Private Sub SearchTerm_Change()
Me.Refresh
CompanySearchList.RowSource = "SELECT CompanyID, Company FROM CompanySearchQ " & "WHERE Company LIKE ""*" & SearchTerm & "*"""
SearchTerm.SelStart = Nz(Len(SearchTerm))
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Developer 8.
