Hello All,

my field contains (must contain) the exact number of 12 characters. Example R9912345-LAX. How can I get a message pop up if a user enters less or more charcters? Even if it doesn't tell which charcter is wrong it makes the user at least check his/her false entry and with a little luck find the error and correct it.

Thanks in advance,

Andy

You can use field validation (under Options) by calculation with:

Length(field) = 12

Depending upon how STRICT you wish to be, you can insist they correct it (unclick Allow User Override) and provide a Custom Message if Validation fails demanding they fix it before leaving; or click Allow User Override to provide a warning and a Custom Message suggesting they repair it. But your words "... must contain..." make it pretty clear which you'll choose.

And unclick (in calculation box) Validate Only If Field Has Been Modified because you want a newly created record to be validated as well. Field validation will not kick in until User leaves the field.

Thank you MoonShadow!