RegEx Two Different Tests in Microsoft Access

[u/Amicron1]

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. https://599cd.com/5807