Validation

[fmousaev]

Hi, i've got a problem here and i hope someone here can help me. I want to make a validation and i want the field allow the user enter a code consisting of 1 or 2 letters in the beginning of it and then 3 digit number after it. Will it be possible to do that and if yes then can someone tell me please.

[CobaltSky]

Yes, it is possible. To get the effect you want, try entering a validation by calculation formula along the lines of:

Length(YourField) > 3 and Length(YourField) < 6 and TextToNum(YourField) > 99 and TextToNum(YourField) < 1000

You might also want to think about entering a custom validation error message describing the format requirements for the field.