InfoPath Dev

Hadn't thought of that. In the past I've created Expression Boxes and once created haven't been able to change them to any other control. Never tried doing the reverse of starting with a Text Box and changing it to an Expression Box. This worked like a charm. And while it was a nuisance to have to do the conversion 21 times and ...

I have a feeling you're on the right track but not sure. I was modifying an existing form. There is a Repeating Section that is filtered (basically like your sample). I needed to add some data, a list of 21 newly added columns to the SharePoint list this data was coming from. I ended up using a Text Box with the concat function, a bit of XML ...

Well, got it sorted out. It probably wasn't the most expedient way to go about things but it's definitely efficient. I did a filter on each colum, matching the IDs so only one result was returned. The thing I'd like to get feedback on with this is my methodology. I had to do this filter 21 seperate times. I'm wondering now if I ...

Okay, I think I see the problem. The form is working the way I told it to, I just didn't tell it exactly what I wanted. :) What I see is it's looking at the entire RelDateA, RelDateB, etc. column and pulling any value it sees. So there are a ton of list items below the one I'm talking about above. Some of them have RelDateA, ...

Okay, to further illustrate the problem, I edited the list item via the form. The list item now shows the first 5 items with entries.   The form shows these 5 records.    Now, when I edit the list item it shows all of these fields blank and only the 7th one with a record (RelDateG). Great!   However, when I open the ...

I wish I had a better way to describe what I'm encountering but here's the details of what I have. One section of my form has a text box with a formula displaying contents (if any) of 21 columns. This is detailed in a different thread, over here. It was working well until I added another control to a different part of the form -- ...

[quote user="Jimmy"] By any chance are those fields in a repeating field of some sort, or are they all separate fields throughout the data source.  Could you post your formula in its current form?  When you added the XML file, did you leave the option "Embed this as a resource file" or something like that checked, ...

Negative Ghost Rider... But after applying that, it worked as described. :) My next question is how can I get the linebreaks to NOT appear if there's no data in the field? See this screen capture of what I'm encountering. I have date columns A-U (21 total) but would prefer only the ones that have data to display. Can this be a ...

Hmmmm, so far I've not been able to make this work. I first added the XML files as a Data Connection (selected Receive type). I then set up a new field in my Main data source to bind a text box to. I created a text box, bound it to the new field and in the formula dialog box set up a few columns with lineBreaks betwen them but no ...

I tried this but with "D" in it. <newLine>
</newLine> <newLine>
</newLine> Alas, no joy... :(