https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/55166.aspxFri, 21 May 2010 05:52:35 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:55166Qazi Anis0https://www.infopathdev.com:443/forums/thread/55166.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=55166<p>check <a href="http://blogs.msdn.com/infopath/archive/2005/03/04/385577.aspx">this</a>.</p>https://www.infopathdev.com:443/forums/thread/55146.aspxThu, 20 May 2010 19:02:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:55146SMuldowney0https://www.infopathdev.com:443/forums/thread/55146.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=55146<p>I have a rich text box that is using the below formula:</p> <p>concat(@PropertyAddress[@FirstAcctNbr = BACNumber1], @PropertyCity[BACNumber1 = @FirstAcctNbr], @PropertyState[BACNumber1 = @FirstAcctNbr])</p> <p>this returns the proper results. The problem I have is that it just dumps the data into the box. I need it to be in a more usable format.</p> <p>The current results look like this: 101Main StKellerTX76148</p> <p>I am trying to make it more like this: </p> <p>101Main St</p> <p>Keller, Tx 76148</p>