heh heh... Other way round.... ;o) Replace(AccessField,chr(10),"<br>","ALL")
Stephen > 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4