Input mask for address

  • Thread starter Thread starter GLW
  • Start date Start date
G

GLW

Is it possible to make something like an input mask to
standardize the way addresses are entered? For example if
I wanted the address to look like "123 E. Main St." it
would always come out that way whether it was entered "123
E Main St" or "123 East Main Street" or some other
variation.
 
Not really. There are tons ov variables. Think of all the abbreviations
for Street, Avenue, Boulevard. What about 123-A Main Street, 123 A Main
Street, etc.

You could build a huge list of possible variations and test, but this is
well beyond the scope of an input mask. An input mask does not handle
abbreviations.

Rick B
 
Is it possible to make something like an input mask to
standardize the way addresses are entered? For example if
I wanted the address to look like "123 E. Main St." it
would always come out that way whether it was entered "123
E Main St" or "123 East Main Street" or some other
variation.
Click to expand...

A Mask is far too weak a tool to manage this.

If you really want fine level control over addresses, consider making
the table fields more granular: rather than a field [Address] try
[AddressNo], [Direction], [Street], [Suffix], [Unit]. On your Form you
could have combo boxes for [Direction] and [Suffix] so the user could
pick only your preferred abbreviations ("St.") rather than typing
anything they want. Do be aware that city planners can get rather
inventive - you'll need abbreviations for Court, Walk, Steps, etc.

The pieces of the address can then be concatenated in a calculated
field for display.

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