check last digit - InfoPath Dev Sign in | Join | Help in Newbie Questions InfoPath (Entire Site) InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads InfoPath Dev » InfoPath » Newbie Questions » check last digit check last digit Last post 04-26-2012 12:03 AM by Jimmy. 1 replies. Page 1 of 1 (2 items) Sort Posts: Oldest to newest Newest to oldest Previous Next 04-25-2012 10:57 PM Tinker Joined on 09-24-2011 Posts 15 check last digit Reply Contact Infopath 2010 I Would like to check the last digit in a social security number if it's 1, 3, 5, 7, 9 then set option button value 1 else set option button value 2 how can this be done ? 04-26-2012 12:03 AM In reply to Jimmy Joined on 07-03-2008 Posts 2,595 Re: check last digit Mark as Not AnswerMark as Answer... Reply Contact Try setting the default value formula for the option button field to this:2 - (substring(SocialSecurity, string-length(SocialSecurity), 1) mod 2) Jimmy Rishe / Software Developer / Microsoft MVPQdabra Software Page 1 of 1 (2 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.
Try setting the default value formula for the option button field to this:
2 - (substring(SocialSecurity, string-length(SocialSecurity), 1) mod 2)