FrontPage 2K3/Access 2K3: Form Output not retain original text for

[8web]

Hello,
We built a FP2K3 Web site with several forms, and used FP2K3' built-in
feature to create associated Access 2K3 databases connected to the forms. We
then used the FP2K3 DB Results feature to display the form results onto .ASP
pages. That all works fine. Except for the formatting of the text in the
Results pages -- there is no formatting, just plain unformatted text.

We need to be able to have the displayed text retain its original input text
formatting, e.g., paragraph settings, font, character attributes (BOLD,
Italic etc), carrage return, line feed et al. Have tried to enable this from
within Access 2K3 -- in the results table -- but unable to do so.

Can you help us please? Any/all assistance would be greatly appreciated.

See one of the forms at:
http://www.trg-reger.com/forms/forms_employmt_openpositions/employment_positions_results5.asp

Thank You!

8web
Aug 9, 2006
.........................................

 

[Thomas A. Rowe]

You will have to insert HTML/CSS tags in the text that you are inserting into the database for it to
be displayed on a page or you can set the HTML/CSS tags around the output fields within your display
page.

If you choose to use CSS, then you will also need to attach a Stylesheet to your output page.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================

 

[8web]

Thank you Thomas,
OK, so how -- practically -- do we actually/exactly do what you suggest?
Sorry, but I need specific steps if you can. For example, three of the
fields in this form -- the Job Summary, Job Description, Required Skills --
must be capable of receiving text in multi-paragraph format, and retain all
other normal MS Word document formats like fonts, indentation, carriage
returns, line feeds, breaks, italics, bold, lists, etc et al. How do we do
this easily, quickly? Thank you very much for any specifics you can give us--
Best,

 

[Jens Peter Karlsen [FP-MVP]]

If it is possible at all it will not be simple or easy and why would
you want to anyway? If you are going to use it on a HTML page it would
have no meaning anyway and if you import it to Word you can just
format it there.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

 

[8web]

Hi JPK--
Thanks for your reply. Appreciate the optimism! Yes, this task just sort of
came up after the fact, once the web project was underway. Am curious,
though, about your reference to 'HTML pages' ... sorry if I mislead you, etc.
As built, the data results are being displayed on .ASP pages .. not HTML
pages. Does this make any difference regarding possible remedies to our
problem?
Thank you!

 

[Ronx]

When viewed in the browser, ASP pages are HTML.

 

[Thomas A. Rowe]

You can not maintain the Word formatting unless your save the page from Word as HTML, then open in
FP, switch to HTML/Code View and copy the content into the field in your database.

On the following site:
http://www.ourcondo.com/Properties/ThePointe.asp

The site owner has to enter the <b></b> tags around the text that he wants to be bold, and for each
paragraph he has entered the <p> tag immediately after the last word in the previous paragraph when
he enter the property description.

Font attributes are hard coded into the page.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================