I need some help with a validation rule.
I have a field with ID numbers, and don't want users to be able to put dashes in the numbers. (I have my report set up to automatically put the dashes in the right places)
I've tried using ="aaaaa", but of course this restricts the amount of letters/numbers the user can type in. I need users to be able to put in as many letters and numbers that they want.
I don't think I can use an imput mask either, because the ID numbers will be different lengths.
Any suggestions?
Thanks, I've learned so much from this board!
I have a field with ID numbers, and don't want users to be able to put dashes in the numbers. (I have my report set up to automatically put the dashes in the right places)
I've tried using ="aaaaa", but of course this restricts the amount of letters/numbers the user can type in. I need users to be able to put in as many letters and numbers that they want.
I don't think I can use an imput mask either, because the ID numbers will be different lengths.
Any suggestions?
Thanks, I've learned so much from this board!