Phone No. Input mask + another Q ....

[Max]

Isn't there an input mask so that a phone number has to be entered as
(111)111-1111?

In a table of names and addresses, is there a way (in Access) to have the
user enter the zip code and have the city and state automatically appear? (I
know that there is in some software, because when I order things over the
phone, sometimes the operator will ask me for my zip code first and then
confirm my city and state.)

Thanks again!

In peace,

Max

 

[Lynn Trapp]

Isn't there an input mask so that a phone number has to be entered as

(111)111-1111?

!(999) 000-0000

In a table of names and addresses, is there a way (in Access) to have the
user enter the zip code and have the city and state automatically appear?

Well, Access does not "automagically" know what cities and states might be
associated with a zip code -- nor, for that matter, does the software that
the phone operator is using. You will need a table of zip codes with their
associated locations. You can then use a combobox on a data entry form to
pull that information. I think you can find that information somewhere --
perhaps you can by doing a Google search.

 

[Max]

Thank you for both answers. I was able to enter the phone no. mask! After
surfing around here, I think what I need to add to the phone number fields is
a validation rule, but when I get the dialog box for validations, I am so
confused, I don't know what any of those terms mean, let alone how to use
them. For now, the mask will suffice, I guess.

Lol, I kind of knew that the computer doesn't really "know" the zip codes,
cities or states....I guess now I have to figure out how to create a combo
box .... wish me luck!

Thanks again!

Max

 

[Lynn Trapp]

Good Luck with it.