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.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm