If you have ever had a need to validate text within MS Access, then these functions should definitely be in your toolkit. With these functions you can perform simple text validation such as filtering all but alphanumeric characters, stripping out alphanumeric characters, and checking if a string is alpha characters.

If needed, I can post a working file if anyone has any problems getting these functions to work. Otherwise, enjoy!

Filter All But Alphanumeric Characters From A String

Strip All But Alphanumeric Characters From A String

Determine If String Is Alpha Characters (Text Only)

Tags: