Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

setting input mask of 4-digits for parameter

Status
Not open for further replies.

breilly192

Technical User
Nov 19, 2002
16
US
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.
 
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

Take a look at the Developer's section of the site for some helpful fundamentals.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top