InfoPath Dev

Hi,

 I have a following formula in my Excel Form:

=IF(RIGHT(A1;1)=MID("0123456789ABCDEFHJKLMNPRSTUVWXY";MOD(LEFT(A1;6)&LEFT(RIGHT(A1;4);3);31)+1;1);"ok";"Error")

 It validates the value in a cell A1.  Data to be validated is Finnish social security number, like: 120365-5312 (fictional but valid)

 How to build a similar validation formula in a InfoPath Text Box Control?

 Cheers,

 Jari

Hi Jari,

What you'll want to do is use  validation rule on the text box. There are default patterns, and you can also create your own. You can set a pattern to be compared to an entry, and also give the user an error if they enter data that does not match the pattern.

In this case, you could use the custom pattern: \d\d\d\d\d\d\-\d\d\d\d

The condition would be, if FieldWithValue does not match pattern \d\d\d\d\d\d\-\d\d\d\d

Hope that helps!
Bre