Displaying fields containing HTML codes

[clarencelai]

Hi,

I have a field that store HTML codes.

How do I output them to MS Access Report / MS Word in HTML format or text format?

Kindly advise.

Regards,
Clarence

[Denburt]

I am not really sure what you are trying to do. One suggestion is to stream it into a file and name the file whatever.html Or you could set up and xml stylesheet so you can export the data to an xml file and use an HTML page to view it... Lots of possibilities. If you wanted to output just the text that is encased in html tags then that might take a bit of work but could be done by hardcoding each tag that you want removed or look for an open bracket "<" Then the close bracket ">" or something along those lines. I think I will need a little more input before I can make any more suggestions. Thanks hope this helps.

[clarencelai]

Hi Denburt,

Thanks for your reply.

I would like the output to be formatted text. For example, if the text stored in the table is "</b>TEST</b>", the output text should be a bold TEST.

Preferably, I could output this to a MS Access Report.

Regards,
Clarence

I am not really sure what you are trying to do. One suggestion is to stream it into a file and name the file whatever.html Or you could set up and xml stylesheet so you can export the data to an xml file and use an HTML page to view it... Lots of possibilities. If you wanted to output just the text that is encased in html tags then that might take a bit of work but could be done by hardcoding each tag that you want removed or look for an open bracket "<" Then the close bracket ">" or something along those lines. I think I will need a little more input before I can make any more suggestions. Thanks hope this helps.

[Denburt]

Hi Denburt,

Thanks for your reply.

I would like the output to be formatted text. For example, if the text stored in the table is "</b>TEST</b>", the output text should be a bold TEST.

Preferably, I could output this to a MS Access Report.

Regards,
Clarence

Well I think I would start in the reports detail section, using the OnFormat event. How good is your VBA? If you code something up and have problems I will be more than glad to help. If you would like some direction I would suggest using the instr() function to locate then remove the "<b>" and "</b>" once this is done then you could format that control to be bold and look for your next tag.

[jaxjagfan]

Never tried this but ...

Access report will display the content of a field whether it is "<b>my text</b>" or "my text".

If you are creating an HTML doc on the fly based on entries in a table you will need to include the header section and body section. This will need to be exported to a text document. If you have a preformatted template text doc with the header already set then WRITE the other elements to the body and close body. Save as HTML.

[rpurosky]

I think what you are really asking is how do you show html enhanced code in a text box, not literally show the codes. I had the same problem and finally figured it out. Go to the properties of the box's Data tab. You'll probably see it by now; the Text Format property has to be Rich Text, NOT Plain Text. Seems odd a property with Format in the name is not found on the Format tab...