Autofill as you type

[Dos Equis]

Hi all,

First, I'm trying to normalize the data in the records and second, I'm
trying to reduce errors in data entry. I'd like to find a simple way
to autofill a text box as I type. The easy example is a city, I have
subscribers from around the country and I'd like to have Dallas spelled
the same in all of the appropriate records.

I'm trying for something that compares what is already typed to a list
of cities either in other records or if I must, in a seperate list.
Idealy, I would have a table containing every city, state and zip code
used in the US and my form would autofill from this data (read create a
link from that data to the record) and solve some data entry problems
for me. My problems are twofold, first, I don't have that table and
can't seem to find one online which would be usable in Access and
second, failing that soloution, I'm not sure how to have Access review
prior records to autofill from that list.

ANY help would be greatly appreciated,

Byron

 

[Marshall Barton]

Dos Equis wrote

First, I'm trying to normalize the data in the records and second, I'm
trying to reduce errors in data entry. I'd like to find a simple way
to autofill a text box as I type. The easy example is a city, I have
subscribers from around the country and I'd like to have Dallas spelled
the same in all of the appropriate records.

I'm trying for something that compares what is already typed to a list
of cities either in other records or if I must, in a seperate list.
Idealy, I would have a table containing every city, state and zip code
used in the US and my form would autofill from this data (read create a
link from that data to the record) and solve some data entry problems
for me. My problems are twofold, first, I don't have that table and
can't seem to find one online which would be usable in Access and
second, failing that soloution, I'm not sure how to have Access review
prior records to autofill from that list.

If can use a combo box instead of a text box, that
capability is built in.

For a text box, you need to use the Change event with a
recordset on the table of cities. you can then use FindFirst
on the text box's Text property. After determining the
appropriateness of the match (or lack of a match) you can
set the Text property. You will also need to mainpulate the
SelStart and SelLength properties so the user's next
keystroke replaces the remainder of a wrong guess. This is
not worth the effort, go with a combo box if at all
possible.

 

[Dos Equis]

If you Google "Access Zipcode Database"
you will find everything from free to spendy.
--
Dave Hargis, Microsoft Access MVP









- Show quoted text -

Jsut saw these responses, sorry for the delay. I found the ZipCode
DB. Thank you Dave. I've now imported it and will try to implement
the combo box suggestion. March, Thank you for suggesting it, I'll
let you know how it works.