Input Mask in Access textbox. Allow only digits, no spaces.
I have a textbox on a form where I only want to allow either four or five digits with no spaces.
Mask 00009 requires at least that the first four entries are digits and the fifth one can either be a digit OR A SPACE.
How can I prevent users from adding a space at the end of the four digits? There must either be a digit or nothing.
Unfortunately the field format is text and can for reference reasons not be changed.