Hi I have a small access database which I have built a report in.  One of
the fields has html tagged/formatted text (memo field) and when I view the
report it shows the html thread instead of actual formatted text.  I want to
display the data in static web pages (on cd) for 10 friends and can't get
the report to display it properly.

Does anyone have any suggestions

Please help

Cheers

Mike

Where did you "build" this report - in Access? Access doesn't render HTML.
Only browsers render HTML. You need to extract the data from Access, and put
it into a webpage and view it using a browser.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Micheal Lee" <micheal.lee@x...>
Subject: [access_asp] reports


: Hi I have a small access database which I have built a report in.  One of
: the fields has html tagged/formatted text (memo field) and when I view the
: report it shows the html thread instead of actual formatted text.  I want
to
: display the data in static web pages (on cd) for 10 friends and can't get
: the report to display it properly.
:
: Does anyone have any suggestions

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

put cstr before the field
If name's data type is memo, go to view   sql view.
When u can see the sql view add Cstr to the field like this.
table name    EMP
column name   Name    data type memo
sql:select Cstr('name')from emp;
It worked for me.
I hope it will work for u.Good luck






>From: "Micheal Lee" <micheal.lee@x...>
>Reply-To: "Access ASP" <access_asp@p...>
>To: "Access ASP" <access_asp@p...>
>Subject: [access_asp] reports
>Date: Tue, 4 Feb 2003 19:28:01 +1300
>
>Hi I have a small access database which I have built a report in.  One of
>the fields has html tagged/formatted text (memo field) and when I view the
>report it shows the html thread instead of actual formatted text.  I want 
>to
>display the data in static web pages (on cd) for 10 friends and can't get
>the report to display it properly.
>
>Does anyone have any suggestions
>
>Please help
>
>Cheers
>
>Mike
>
>


_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail