Smart Address Checking

L

Lynn

Does anyone have suggestions how data in Access can run
through a program to verify that the city, state and zip
codes provided for an address record are valid? Program
such as PostalSoft?
 
J

John Vinson

Does anyone have suggestions how data in Access can run
through a program to verify that the city, state and zip
codes provided for an address record are valid? Program
such as PostalSoft?
Click to expand...

Have tables of State and Zip (with a City field in the Zip table) as
part of your application; rather than letting users type anything they
want in these fields and then slapping their hands when they do it
wrong, give them a Form with combo boxes based on these tables so
they're only able to select valid values. As a backup, establish
relationships, referential integrity enforced, between your address
table and the city/zip tables.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
J

John Nurick

Hi Lynn,

What John Vinson says - but you may want to make sure that there's some
way to disable the validation for a single record, or you'll never be
able to enter an international (even a Canadian) address.
 
Top