 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / August 2004Postal Codes
Does anybody know of a workable Input Mask for a Postal Code. Thanks D 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 >Does anybody know of a workable Input Mask for a Postal >Code. > >Thanks >D -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. How do you use regex in microsoft Access? 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. >How do you use regex in microsoft Access? -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. See also my post just now under the subject "Insert Dashes". >How do you use regex in microsoft Access? -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.