Format Access memo field?

[timsilva]

Hi all,

Just trying to figure out how to format a returned MS Access memo field with Coldfusion.
Nothing special. Just want it to retain returns and paragraphs...

Thanks,
Tim

[Ken Ford - *TMM* & PVII]

Tim,

Use ParagraphFormat()

#ParagraphFormat(stringToFormat)#

--
Ken Ford
Certified Dreamweaver MX 2004 Developer
PVII Support Team
[url]http://www.projectseven.com[/url]
Team Macromedia Volunteer - Dreamweaver


"timsilva" <webforumsuser@macromedia.com> wrote in message news:cv181r$fac$1@forums.macromedia.com...

> Hi all,
>
> Just trying to figure out how to format a returned MS Access memo field with Coldfusion.
> Nothing special. Just want it to retain returns and paragraphs...
>
> Thanks,
> Tim

[timsilva]

Thanks Ken,

All better.
:-)
- Tim

[keann]

I have been looking for two days for this answer, and now that I've read it, I
don't know exactly how to apply it. I have data in an Access database Memo data
type field. I created a recordset and a dynamic table to display the data from
Access. The memo data type is not formatted when returned in ColdFusion. If I
use the <pre></pre> tags in Dreamweaver, it's formatted in ColdFusion, but I
can't get the text to wrap in the column, therefore, the column is extremely
wide.

Here is my code:
<cfoutput query="printmanual">
<tr>
<td>#printmanual.PolicyNumber#</td>
<td>#printmanual.PolicyTitle#</td>
<td>#printmanual.PolicyDescription#</td>
</tr>
</cfoutput>

PolicyDescription is the Memo data type field. How do I view it in ColdFusion
in it's original format with paragraphs?
I really, really appreciate any help. Thank you,
Kelli

[SafariTECH]

wasn't your question answered by the post prior to yours?

#ParagraphFormat(stringToFormat)#

in your case

#ParagraphFormat("#printmanual.PolicyDescription#" )#

drop the pre tags

[jorgepino]

you could use this!
'#ReplaceNoCase(printmanual.PolicyDescription,'#Ch r(13)#','<BR>',"all")#'>