Data Validation help - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Data Validation help

Last post 08-30-2006 11:28 AM by Sharksfan. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 08-27-2006 01:09 PM

    Data Validation help

    I'm a noob and am in a quandry.....

    I have multiple Yes/No option buttons that I want to be required fields via data validation against multiple checkboxes. If any of four specific checkboxes are "true/checked" I want the option buttons to be required fields for the user.
    I tried this first using data validation within the option buttons looking at all four checkboxes, but the multiple OR statements never seem to trigger the requirement for the option buttons :(
    I also tried adding an Expression box that would be "false" unless any one of the checkboxes was "true", but had trouble getting the expression formula to work. Any suggestions or help is much appreciated.
  • 08-29-2006 06:20 PM In reply to

    Did you make sure to put the validation of the "cannot be blank" in there? This seems like a mistake that would be easy to make. So your condition for invalidity would be something like this:

    (CB1 = true or CB2 = true or CB3 = true or CB4 = true) and OptionSelection = ''
    Matt Faus / Microsoft InfoPath MVP
    Qdabra® Software / Streamline data gathering to turn process into knowledge
  • 08-30-2006 11:28 AM In reply to

    Thanks Matt.

    I just found a solution this morning that works for me. I had previously tried to have all of my four checkboxes be validated within one statement using the multiple ORs, but the solution for me was to create multiple Validation statements....one for each of my four checkboxes.
    So I ended up with four validation statements like this....Add = "TRUE" AND Correct_Contract_dates is blank....then Correct_Contract_dates is a required field
    Works like a charm!

    Thanks for replying.
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.