AnsweredAssumed Answered

Validation Field Options

Question asked by eibcga on May 28, 2010
Latest reply on Jun 10, 2010 by eibcga


Validation Field Options


I'm new FMP11 user on Mac OS X 10.6.3.


There's a check box for Maximum number of characters in Field Options… Validation.  What if I want to set the Minimum number of characters?  I have a Date field as a number type rather than as date type, and I enter the date as YYYYMMDD.  I set the field option, Validation, to Maximum number of characters to eight (8), and would also like to set the Minimum number or characters to eight (8), but the option is not there.  Must I use an IF formula using the check box "Validate by calculation" and click the specify button, then create the appropriate formula, in this case?  Any ideas?