I started working with InfoPath earlier this year and created a form that was sent out to users via Outlook and submitted back the same way. The form consists of a drop down box at the top and then various text boxes as control fields. I conditional formatted some of the text boxes to be hidden when certain values in the drop down box are selected because I don't want users to enter values where they aren't needed.
My issue is that for only 1 form out of many that I have received back, a value is popping up for one hidden field in the results when I export them to excel. The field is hidden and the users aren't able enter anything it in. The value is not a part of the field properites. When I recreate my own version selecting the value in the drop down and fill out other fields and export, the value is not there in the results. It's a very peculiar thing and I can't figure out how that value got into the form the user submitted - nor can I figure out how to get it out of the results (besides manually deleting it from the excel cell which is what I've reverted to). I am not sure how to 'dig' into what the user submitted to get more information.
I am working with Office 2007.