I am trying to create a textbox that when the user types in it ...the records get searched/queried by it's value. I am pretty close but it is having trouble if I type a "SPACE" it doesn't count it, or removes it or something.
example: A B C House never works. ABCHouse works.
Anyway: below is what I have, positioning the mouse is where I am having the issue.
Just to be clear the query works...don't need help there yet ;).
Thanks experts hope I was clear.
Private Sub txtSearch_Change()
.SelStart = Nz(Len(.Value), 0)