Geek asks and answers

Can I fill in Microsoft Access autocomplete fields?

I am using Microsoft Access 2007. When I start entering a new entry, is there a way to access the sentences that I previously entered to save time typing the whole word? For example, when I start typing S, it can start to suggest words that I have already typed, starting with S, then if I type ST, it can offer STATION, and can I just press Enter to insert this word?

+5
source share
1 answer

Your question includes a tag for combobox; It seems to me that this may be the most inexpensive solution.

Make a request to the combo line:

SELECT DISTINCT YourField
FROM YourTable
ORDER BY YourField;

combo "limit to list" "No", , .

, "" VBA ". ".

, YourField. .Requery On Current, "" .

+5

More articles:


All Articles