I have a rich text box that is using the below formula:
concat(@PropertyAddress[@FirstAcctNbr = BACNumber1], @PropertyCity[BACNumber1 = @FirstAcctNbr], @PropertyState[BACNumber1 = @FirstAcctNbr])
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.
The current results look like this: 101Main StKellerTX76148
I am trying to make it more like this:
101Main St
Keller, Tx 76148