asked on 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.
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.
Microsoft Access
Last Comment
Gustav Brock
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks. I did not even try, because I read http://office.microsoft.com/en-za/access-help/input-mask-syntax-and-examples-HP005187550.aspx
It says there
9 Digit or space (entry not required; plus and minus signs not allowed).
So I did not want to allow a space.
It says there
9 Digit or space (entry not required; plus and minus signs not allowed).
So I did not want to allow a space.
You are welcome!
/gustav
/gustav
You could use the Trim function to eliminate the space
Regards