Front Page - Showing Memo field in Database Results

Author

Showing Memo field in Database Results

J. Sacks

2004-07-30, 7:15 pm

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

2004-07-30, 7:15 pm

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.

"J. Sacks" <jill.sacks@ssa.gov> wrote in message
news:cee4f1$q37$1@s0b1a68.ssa.gov...
> 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!
>
>

Kathleen Anderson [MVP - FP]

2004-07-30, 7:15 pm

http://home.att.net/~codelibrary/Fr...m#Line%20Breaks

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

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

J. Sacks <jill.sacks@ssa.gov> wrote:
> 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!