Displaying HTML within an Access Report

16 Dec 2005 1:19 PM

Dooza

Is this possible? I have a column which has data with HTML formatting.
Is it possible to remove the tags within a Stored Procedure so that it
displays nicely in an Access Report?

This is my SP:

ALTER PROCEDURE dbo.sp_Phat_Beats
AS SELECT     fldcat, flddescript, fldtracklisting, fldprice, fldCategory
FROM         dbo.tblProducts
WHERE     (fldprice <> 0) AND (fldCategory = 17)
ORDER BY fldcat

fldtracklisting is the field that is HTML formatted. Any help would be
relly appreciated.

Steve

16 Dec 2005 4:48 PM

John Bell

Hi

You could use replace multiple times to remove each tag, but this would
require embeded calls to the procedure one call per string you wish to
replace which could prove tedious. Check out replace in Books online

John

Show quote

"Dooza" wrote:

> Is this possible? I have a column which has data with HTML formatting.
> Is it possible to remove the tags within a Stored Procedure so that it
> displays nicely in an Access Report?
>
> This is my SP:
>
> ALTER PROCEDURE dbo.sp_Phat_Beats
> AS SELECT     fldcat, flddescript, fldtracklisting, fldprice, fldCategory
> FROM         dbo.tblProducts
> WHERE     (fldprice <> 0) AND (fldCategory = 17)
> ORDER BY fldcat
>
> fldtracklisting is the field that is HTML formatted. Any help would be
> relly appreciated.
>
> Steve
>