This may help: ReplaceNoCase("#accessfield#", "<p>", "#CHR(10)#", "ALL")
-- Sam -----Original Message----- From: David Green [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 10:32 AM To: CF-Talk Subject: Access Memo Field I know this question has been answered many times before but I can't find it in the archives and I don't use CF all the time. Heck new layout on houseoffusion I had hard time finding way to search the archives. Ended up finding link to old archive search. The link to archives at the bottom of posts does not seem to take to a archive search. But am sure am missing something. How do I convert line feeds and carriage return formats in a access field to HTML. I have tried paragraphformat but the does not do it. Client inputted in table $69/dbl $79/sgl On output am getting $69/dbl $79/sgl Need upper. Thanks for the help and postings David ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4