breilly192
Technical User
I was trying to set a validation with an input mask of four digits to a specific field so that someone inputting the parameters could not enter the incorrect number of digits. While using 0000 did not allow someone to enter a letter, it still allowed me to type in only one digit, or more than four, before going to the next parameter.
Also, is there any way to restrict query input parameters to a specific range, say 1000 to 2000 for example, without creating a form? I'm using linked tables and couldn't change the validation rules of the table.
Also, is there any way to restrict query input parameters to a specific range, say 1000 to 2000 for example, without creating a form? I'm using linked tables and couldn't change the validation rules of the table.