Passing Formats Thru Access To FrontPage

[Janie]

How do I pass the format of a document into an Access memo field and then
into a FrontPage Database Results region?

The results I have now strip off all formats including paragraphs so that a
document that had several paragraphs appears as one paragraph. The same
question applies for bold, italics, font color and blockquotes.

Thanks for the help.

 

[Stefan B Rusynko]

HTML "coding" in a DB field needs to be displayed using Server.HtmlEncode
See http://www.w3schools.com/asp/met_htmlencode.asp

So to display Html from a memo field (FieldnameMemo) use
<%
Dim strMemo
strMemo = fp_rs("FieldnameMemo")
' or use the FP "format' as: strMemo = FP_FieldVal(fp_rs,"FieldnameMemo")
Response.Write Server.HtmlEncode(strMemo)
%>

Also see
http://www.frontpagehowto.com/formatmemo.asp or
http://home.att.net/~codelibrary/FrontPage/tweaks.htm



| How do I pass the format of a document into an Access memo field and then
| into a FrontPage Database Results region?
|
| The results I have now strip off all formats including paragraphs so that a
| document that had several paragraphs appears as one paragraph. The same
| question applies for bold, italics, font color and blockquotes.
|
| Thanks for the help.
| --
| Janie

 

[Kathleen Anderson [MVP - FrontPage]]

I normally copy the Word document into Notepad, from there into an empty web
page in FrontPage, format it the way I want it, and then copy it from
FrontPage into the Access memo field. In the Database Results Region,
right-click on the field in Design View and choose Column contains HTML.