June 7, 200718 yr Newbies I have a numeric type field and i want to fill the field with a 4 digit number.if the input of the number is less than 4 digits or bigger than 4 digits i want to allert me that the input is not correct.i have validate the field that the max number of characters is 4.How do i validate the field that the minimum number of characters is also 4?Can anyone help?
June 7, 200718 yr If it is a number field, try: numField :great: 1000 and numField :less: 9999 That should take care of it all, if I understand your needs correctly.
June 7, 200718 yr Try a validation by calculation of: Length (Trim ( Yourfield ) ) = 4 or since it is a numberic field, you could use a validation by range from 1000 to 9999
June 7, 200718 yr Author Newbies thanks both of you.all your solutions worked for my problem.thanks again
Create an account or sign in to comment