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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Limit Number Value By Using a Input Mask

Status
Not open for further replies.

scholarthewise23

Technical User
Jun 24, 2003
8
US
Is it possible to create a input mask that would limit the value to a certain range of numbers. For an example - My input mask right now is .00;;_ or a range of .00 to .09. I want the range to be .00 to .03. If this possible show me the expression to be use. Thanks in advance!
 
On your input form, you could use the VALIDATION RULE property and enter this: Between 0 and .03

then in the VALIDATION TEXT property, put the message you want, like "Please enter a value between 0 and .03!
 
Thanks for the reply - Im getting a error code although saying: The value you enetered dosn't meet the validation rule.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top