RichO
Registered Yoozer
- Local time
- Today, 01:03
- Joined
- Jan 14, 2004
- Messages
- 1,036
I searched through the archives and the only post I could find with the same question as mine contained an outdated link in the response so I could not find any answers.
We have a form set up for a CD music library. Often times there are duplicate artist names to enter and I would like to have it auto-complete the field just like Excel does. A combo box would be out of the question because there are thousands of entries.
Does Access have any sort of built in function that can be activated for this or do you have to set up an event procedure, and is that even possible as far as tracking each character for matches as it is typed. To clarify...
If you type "BEA" it either would not display a match because the table contains more than one artist starting with those letters (BEATLES, BEACH BOYS), or it would lock on to the first match found which would be OK. Then you type a "T" to make it "BEAT" and it auto-completes the field with BEATLES.
I tried to run a query on the artist field using "Like" but I can't figure out how to get it to track the text I am typing because the field is not updated until enter is pressed.
Any ideas? Is this even possible?
We have a form set up for a CD music library. Often times there are duplicate artist names to enter and I would like to have it auto-complete the field just like Excel does. A combo box would be out of the question because there are thousands of entries.
Does Access have any sort of built in function that can be activated for this or do you have to set up an event procedure, and is that even possible as far as tracking each character for matches as it is typed. To clarify...
If you type "BEA" it either would not display a match because the table contains more than one artist starting with those letters (BEATLES, BEACH BOYS), or it would lock on to the first match found which would be OK. Then you type a "T" to make it "BEAT" and it auto-completes the field with BEATLES.
I tried to run a query on the artist field using "Like" but I can't figure out how to get it to track the text I am typing because the field is not updated until enter is pressed.
Any ideas? Is this even possible?