January 17, 200620 yr Hello all, I need to define a field so that on data entry you can only enter 13 digits an not more not less than that (only numbers). I found the MAX but no MIN. Thank you. Edited January 17, 200620 yr by Guest
January 17, 200620 yr If it is a strictly 13-digit number you could perhaps do a range validation 1 followed by 12 zeroes up to 13 9's
January 17, 200620 yr Hmmm.. 13 zeros is numeric only, AND has the required number of characters. Is it valid? How about: Length ( field ) = 13 (which also means not empty)
January 17, 200620 yr Author I tried this also, the only thing that works is when I leave it blank it shows my message to add a number in to that field. I can enter any muber of digits and it is OK with it???
January 17, 200620 yr comments's solution works for me. You sure you set it up as a validation? What doesn't it do? Lee
January 17, 200620 yr Author I finally got it figured out... thank you. this was fast help - almost like paramedics Edited January 17, 200620 yr by Guest
Create an account or sign in to comment