Display HTML formatted data in Access form
Posted on 2012-12-21
I am creating a form which pulls its data from a linked MS Sql server database. In that database is a column which stores the data as HTML. I join that table to a couple of others in a query which is the record source for my form. The column in question is a text format – that comes from the sQL server database.
I would like for this data to display correctly, although it would be OK if the HTML formatting were lost. When I display that column in my form, all the HTML tags show. Changing the format to RTF does not correct this, apparently that only works if the underlying field is Memo format.
I’ve searched here and other similar sites and found some hints that I could use the web browser control but not any clear instruction on how to do it. In my experiments I haven’t been able to figure out how to make the data in each row show up in the web browser control. (In fact, I’ve been using the control ‘Hyperlink’, not finding a control actually called ‘Web Browser’… surely they are the same, right??)
Anyone able to help me with this please? As an alternative I would be ok with losing the HTML formatting in the query if there is some way to do that - maybe a calculated column that pulls the text data from the HMTL?