When I have the code below (at bottom of this post) directly in my Sbasic it prints perfect with my printstring() commands. But if I retrieve it from an element in another database  using xlookup directly below it is all screwed up

vLTRTEXT  = @XLookUp(@FN, VltrNum, "Letters!LetterNum", "LetterText")

I thought it might have something to do with multiline text element vs single line but I get the same results either way I set the element. I tried some @replace(vLTRTEXT, @chr(9), ";") type stuff but never got it correct.

What am I missing?

Thanks


    vLTRTEXT =  "      Enclosed please find the information that " + vofereeSalesPerson + " requested we send to you about our "+ propertyName +
                " Project. The Attached documents will outline the history, challenges, opportunity, and the details of the offering." +
     @NewLine() + @NewLine() +

     "      Hopefully this packet will answer any questions you have regarding the property and why we have chosen this " +
     "property to invest in." +

     @NewLine() + @NewLine() +  "       We have also included a little background information on  and his previous "+
     " successes putting together similar investments.  If you have any questions that are not answered in the following "+
     "pages, please feel free to call " + vofereeSalesPerson + " at " + vSalesPersonPhone + "." +

     @NewLine() + @NewLine() + "       Please read and sign the attached paperwork and return it to us in the self addressed " +
     "stamped envelope included." +

     @NewLine() + @NewLine() + "       Thank you for giving us this opportunity to show you why Group of Companies "+
     "has been a reliable, respected and admired source of quality real estate investments for 50 years." +

     @NewLine() + @NewLine() + @NewLine() + 
     "                                  Group of Companies"

Ray,

I sent 2 pdf to you that shows the difference between the outputs. I would bet I am gettig some kind of embedded char when I use the lookup. But I cant figure it out.

Thanks

Thanks Ray 

As usual you solved my problem. Customer Service at its BEST!