setting input mask of 4-digits for parameter

[breilly192]

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.

 

[JeremyNYC]

I don't think it is possible to restrict the range of parameters input, but I'm not sure. I'd say just create the form. It sounds like you are doing some serious checks on what gets input. It will only take a little time to build the form, and it will be much more powerful and flexible (or not, as you'd like) than a parameter query.

Jeremy

=============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.