D
DMc2003
Does anybody know of a workable Input Mask for a Postal
Code.
Thanks
D
Code.
Thanks
D
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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
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
A
Alex
How do you use regex in microsoft Access?
J
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.
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.
J
John Nurick
See also my post just now under the subject "Insert Dashes".