HTML in Database

[Bil Click]

I have a report that pulls data from a field that has HTML code, specifically
"<BR>" and " ". How can I make my report insert a carriage return command
instead of displaying the "<BR>", and display "white space" instead of " "?
Thanks...

 

[Douglas J. Steele]

Replace(Replace(MyString, "<BR>", Chr(13) & Chr(10)), "?", " ")

 

[Bil Click]

Thanks for the reply Doug. Where do I insert this replacement code?

 

[Douglas J. Steele]

Do you want to keep the HTML, but change it for your report only? Best would
probably be to have a computed field in the query on which the report is
based, and use that computed field rather than your existing field.

 

[Bil Click]

Thanks again Doug, I will try that.

Do you want to keep the HTML, but change it for your report only? Best would
probably be to have a computed field in the query on which the report is
based, and use that computed field rather than your existing field.