. Create a validation rule that will only accept numbers greater than 10 and less than 20
Validation RuleA validity check also can restrict input to values that are between certain limits. A rule such as >10 And < 20 will force users to enter values between 10 and 20. To insure a user-friendly interface, you can use the validation text property to display a message such as "Please enter a value greater than 10 and less than 20. Field Size -> 1 Format Input Mask Caption Default Validation Rule -> 10 or 20 Validation Text -> Please enter numbers greater than 10 and less than 20 Required -> Yes
Get Answers For Free
Most questions answered within 1 hours.