Postal Codes

[DMc2003]

Does anybody know of a workable Input Mask for a Postal
Code.

Thanks
D

 

[John Nurick]

Hi D,

There is no input mask that will work for all postal codes. Either trust
the user, or write code to validate what the user has typed (taking into
account international addresses etc.). There's informatoin on postal
codes at http://www.columbia.edu/kermit/postal.html , and a
general-purpose validation function with postal code examples at
http://www.mvps.org/access/modules/mdl0063.htm

 

[Alex]

How do you use regex in microsoft Access?

 

[John Nurick]

Hi Alex,

You can use the VBScript Regex object (in the Micrososoft VBScript
Regular Expressions 5.5 library). This
http://www.mvps.org/access/modules/mdl0063.htm is an example of using
it.

 

[John Nurick]

See also my post just now under the subject "Insert Dashes".