Looking for a number somewhere in a note is not the same as checking the entire field. [0-9]+ finds a run of digits, while ^[0-9]{5}$ checks for exactly five digits from start to finish. That checks the format, not whether a ZIP code exists. Watch the video to see both tests in Access VBA.
For a complete step-by-step video tutorial on this topic, including additional examples and explanations, please visit https://599cd.com/5807.
No comments:
Post a Comment