View Single Post
  #4  
Old February 11th, 2005, 06:26 PM
Lynn Trapp
external usenet poster
 
Posts: n/a
Default

Good Luck with it.

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


"Max" wrote in message
...
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" wrote:

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