I have a text box and I want to limit the user to entering only letters and numbers in it. In particular, no spaces should be allowed. The entry can have up to five characters. I'd use an input mask of AAAAA except that the user needs to be able to enter values with fewer than five characters in some cases.
It doesn't matter to me if the solution rejects the characters as the user types them or if it waits until they've completed the entry for the field and then validates the entry.
I could just write a routine to cycle through each character and verify that it's a letter or number but I'm curious if there's an easier way.
It's an unbound field so I can't verify it at the table level.