check last digit - InfoPath Dev
in

InfoPath Dev

check last digit

Last post 04-26-2012 12:03 AM by Jimmy. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 04-25-2012 10:57 PM

    check last digit

    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

    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 MVP
    Qdabra Software
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.