Dynamically filtering data 1

[eAlchemist]

I have a textbox that I'm using for the user to filter records in a form. As they type, I want to filter the recordset, so I use the onchange event to refresh the data. But, when I do form comes back with all of the text in the textbox highlited. Any way to prevent this or to get the cursor to appear at the end so that this is invisible to the user?

Thanks,
Chris

 

[PHV]

Take a look at the SelStart and SelLength properties of the TextBox object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[cghoga]

try...

Me!nameoftextbox.SelStart = Me!nameoftexbox.SelLength

hope this helps.

 

[eAlchemist]

Tek-Tips rocks, OF COURSE.

Thanks Guys.

Chris