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
                                

Reply via email to