I've built my own (crude) version control system for Access and I'm looking to validate the version number in my update log table.
The version number should match the regular expression [0-9]+\.[0-9]+[a-z]? but I can't figure out how to implement this as a validation rule for the field. Can this actually be done, if so, how?
Note: I'm fairly fluent with VBA so VBA-based solutions are fine
