Display Optional Text

[brsawvel]

Hello All,

I was wondering if there was a code to place on a textbox so that when I begin to enter text into the box, it brings up previous field entries in that column that begin the same way (just like Excel does when you begin typing a word that appears in the same column somewhere else)?
I thought it might be in one of the "autofill" threads, but I found that those deal mostly with pasting the last entry into your new record.

 

[boblarson]

Hello All,

I was wondering if there was a code to place on a textbox so that when I begin to enter text into the box, it brings up previous field entries in that column that begin the same way (just like Excel does when you begin typing a word that appears in the same column somewhere else)?
I thought it might be in one of the "autofill" threads, but I found that those deal mostly with pasting the last entry into your new record.

You could code for this, but I'll tell you right now that the overhead needed to do it will slow your database entry down to a crawl. You would need to have it search on each keystroke and Access is not a multi-threaded application, so it will perform what you ask, but will need to wait until it is done before it processes the next keystroke. It may be possible to include a DoEvents in the code, but I seriously doubt that your performance would be good enough to make it worthwhile.

Yes, it's a nice user-friendly feature, but it isn't really feasible within the application.

 

[brsawvel]

If it slows down the application too much, maybe I shouldn't use it then. No big deal. Thanks for the response.