Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
Course Of The Month
3 days, 15 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
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?
Thanks -
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?
Thanks -
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4-
3
7 Comments
If you're using Access 2007 or later, you can use the PlainText() function to remove the HTML tags.
=PlainText(NameOfFieldWith
=PlainText(NameOfFieldWith
You can also add an unbound textbox to your form and change it's TextFormat property to Rich Text. Then in the OnCurrent event of your form add something like:
Me.NameOfRichTextbox = [NameOfFieldWithHTMLstring
This way you would see the text displayed almost as you would in a browser (whatever RTF is able to render properly since it cannot handle all HTML tags).
Me.NameOfRichTextbox = [NameOfFieldWithHTMLstring
This way you would see the text displayed almost as you would in a browser (whatever RTF is able to render properly since it cannot handle all HTML tags).
I tried both of these solutions and both are still displaying the HTML tags. Access version is 2010.
I am not experienced in HTML so maybe there is something more going on with this field that I don't understand, but I do know that when I place it in a Crystal report and format it as HTML they display properly...
Here is a sample of the data in this field:
"<style type=""text/css"">
body {font-size:8pt;font-family
td {font-size:8pt;font-family
</style>
<html><body leftmargin=""0"" topmargin=""0"">
<ul>
<big>• </big><b>1- 6 in (H) x 2 in (W) Dimensional Sign(s)</b> made from <b>Coro - 10 mil White 48 x 96</b> stock material <br>
</ul>
</body></html>"
On further investigation, when I look at the table design in Access (read-only, of course) it shows as a memo data type, which I understood should display correctly using RTF formatting in access:
So I am even further confused why it does not display the HTML since as I understand it Access should render the HTML in these circumstances.
Any further suggestion on this solution?
And if anyone has the answer to my initial question about using the Web browser control that would be appreciated as well...
Thanks,
I am not experienced in HTML so maybe there is something more going on with this field that I don't understand, but I do know that when I place it in a Crystal report and format it as HTML they display properly...
Here is a sample of the data in this field:
"<style type=""text/css"">
body {font-size:8pt;font-family
td {font-size:8pt;font-family
</style>
<html><body leftmargin=""0"" topmargin=""0"">
<ul>
<big>• </big><b>1- 6 in (H) x 2 in (W) Dimensional Sign(s)</b> made from <b>Coro - 10 mil White 48 x 96</b> stock material <br>
</ul>
</body></html>"
On further investigation, when I look at the table design in Access (read-only, of course) it shows as a memo data type, which I understood should display correctly using RTF formatting in access:
So I am even further confused why it does not display the HTML since as I understand it Access should render the HTML in these circumstances.
Any further suggestion on this solution?
And if anyone has the answer to my initial question about using the Web browser control that would be appreciated as well...
Thanks,
I just tried what you gave and it does render the HTML tags correctly. The problem is that you also have CSS style tags. As I said, RTF can only render certain types of tags.
For the Web Browser control, you have to select ActiveX Controls on your ribbon (where the other controls are). The one you need is called Microsoft Web Browser. Add that to your form and give it a name (e.g. ctlWebBrowser). Then add this code to your OnLoad event to "initialize" the browser.
Me.ctlWebBrowser.Document.
For the Web Browser control, you have to select ActiveX Controls on your ribbon (where the other controls are). The one you need is called Microsoft Web Browser. Add that to your form and give it a name (e.g. ctlWebBrowser). Then add this code to your OnLoad event to "initialize" the browser.
Private Sub Form_Load()
'Needed to "initialize the webbrowser control,
Me.ctlWebBrowser.Navigate "about:blank"
Do While ctlWebBrowser.ReadyState <> 4
DoEvents
Loop
End Sub
Me.ctlWebBrowser.Document.
Alas, this is a continuous form and the html data is only appearing on the current row...
I don't suppose there is any solution for that problem?
so close and yet so far away!
I don't suppose there is any solution for that problem?
so close and yet so far away!
Unfortunately this will not work in a continuous form. How about adding an unbound textbox set to Rich Text and use this expression in its ControlSource:
=Mid([FieldName],IIf(InStr
The above looks for the <HTML> tag in your field and ignores the text before it. That way the rest can render properly.
=Mid([FieldName],IIf(InStr
The above looks for the <HTML> tag in your field and ignores the text before it. That way the rest can render properly.
Featured Post
On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s
ManageEngine
webinar, where attendees received a comprehensive look at the ma…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
…
Suggested Courses
Course of the Month3 days, 15 hours left to enroll
691 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.