Showing Memo field in Database Results

[J. Sacks]

I'm displaying information from a database using the Database Results
Wizard. One of the fields is a memo field and has alot of text in it. When
viewing it in Frontpage 2003, the information in the memo field is displayed
in one long line in the table, rather than wrapping into a paragraph. Is
there any way of changing this to display in a paragraph format, rather than
one long line? Thanks!

 

[Kevin Spencer]

In HTML, line breaks are treated like spaces or any other white-space
character. They are treated as a single space. In HTML, line breaks are
indicated with a <BR> tag. Therefore, you need to replace all incidents of
VbCrLf (VB for Carriage Return/Line Feed) with the string "<BR>".

I'm not very familiar with the FrontPage DRW, but I can give you the basic
syntax of ASP:

<%=Replace(YourDatabaseValue, VbCrLf, "<BR>")%>

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

 

[Kathleen Anderson [MVP - FP]]

http://home.att.net/~codelibrary/FrontPage/tweaks.htm#Line Breaks

N.B. This 2nd option of this tweak needs a minor tweak; change "<br/")% to
"<br/>")%