When you insert the value as is in a memo field it whould retain the carriage return.. If you show the value of the memo field in a textarea you should see the carriage return.. The replace solution is to show the value as text in html not in a textarea.. But carriage return are preserve as is when you insert the value in a text or memo field
Pat -----Original Message----- From: Roberto Perez [mailto:[EMAIL PROTECTED] Sent: November 5, 2004 03:15 To: CF-Talk Subject: RE: formatting in textarea At 06:16 PM 11/6/04, Pat wrote: >Just do this : > ><cfset locCarriageReturn=chr(13) & chr(10)> > ><cfoutput> >#replace(your_variable,locCarriageReturn,"<BR>","ALL")# ></cfoutput> Thanks for the several solutions proposed. However, here's my doubt: if the text in the "Memo" field in Access is being stored without carriage returns, that means that whatever code or tags I use would have to be employed as data is *sent* to the database, so that carriage returns are included in that text. Can any of these solutions (e.g., "locCarriageReturn", "ParagraphFormat", etc.) be used *before* the data is stored (i.e., as data is sent), so that carriage returns are preserved? Thanks in advance, Roberto Perez [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183570 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
