Address AutoComplete - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Address AutoComplete

Caleb Hansen

3 years ago

Richard-

Maybe you already have this somewhere and I can't find it, but I would love to have a similar function that you find on Google maps or other websites where you start typing the address in an address field and address suggestions pop up for you to select and auto-fill the Address/City/State/Zip fields. I have attempted to start this on my own but couldn't quite make it work. I downloaded all of the addresses from the National Address Database from Transportation.gov. It comes in a text file with the data separated by commas so you can import this into excel. The text file is like 5gb, so it's a monster. I tried running a power query in excel to eliminate all of the columns I didn't need and then filter the rows so that I only got the address's for California since this is all I wanted anyway. This is still a very large file and I know I would need to keep this under 2gb unless I put this on SQL server and link it to my front end. I cut the file down to 10 mb worth of address's and plopped in the frontend to play around with it, but I couldn't make it work the way the websites do. Is this something you might make a video on if you haven't already? Thanks for all you do.

	Kevin Robertson @Reply 3 years ago
The Search As You Type video may give you some ideas on how to make this work. Also: Search Form 2.0 Wildcard Search & Like DLookup

Kevin Yip @Reply

3 years ago

Autocomplete only works for text that begins with what you just typed. But address searches are different. What you just typed could be in he middle, the end, or the beginning of an address. So what you need is "search as you type" as mentioned above. If you use Google contacts, you can see how this works at https://contacts.google.com/ . Type in anything, and instead of autocompleting for you, it will give you *a list* of contacts that match what you typed not necessarily at the beginning, but anywhere in the name and email address. This can be certainly done in Access. Autocomplete isn't possible in Access in its current version anyway, but older versions did have a "web app" feature that had an "autocomplete control."

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View