Up Dating Street Names.

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

When I'm entering member's address details into a form, is
there any way of setting Access to auto complete the
street names as I type them? Eg 17 Alfa Street.
I tried a combobox but once you start typing the house
number, space and then the street name, if that number and
street have not been entered before it does not work.

Is there any ways of making this easier without using
multiple fields?

Any help appreciated.

Nick
 
Nick said:
When I'm entering member's address details into a form, is
there any way of setting Access to auto complete the
street names as I type them? Eg 17 Alfa Street.
I tried a combobox but once you start typing the house
number, space and then the street name, if that number and
street have not been entered before it does not work.

Is there any ways of making this easier without using
multiple fields?
Click to expand...

No. if the number and street are not there, then they can't auto complete.
You would have to separate the number from the street name.

If you have a lot of them you might want to consider buying the addresses
and importing them.
The down side to that is if you really want to save postage, you have to
sort by the way the carrier delivers and that means all the odd in one
direction, then the even in the other direction except in some cul-de-sacs
or mobile home parks (except in some mobile home parks.....)
 
Back
Top