Hello,
I have a Access Data Project with a table that stores HTML text in a field. That text is used to populate the body of a email message (MS Outlook). The HTML code is stored in the table as a string (nvarchar in the SQL back end).
When it is placed into the email editor, the HTML tags show up correctly and the data is populated in a table.
I have built a form that is used to show the data stored in that table. But rather than have the HTML text show up as code on the form (with the tags, i.e. <tr> </tr>, etc. I'd like for it to show up like it does in the email.
I realize it shows up the way it does in the email message because of the Outlook editor. But I am wondering if MS Access (mdb and adp) has built in functionality that permit this type of view or if this can be done with vba.
I have read some articles about using ASP.net, but I am not sure how to do this. Just wondering if any of you have any suggestions or if you can point me to some resources on this.
thanks,
Ben
I have a Access Data Project with a table that stores HTML text in a field. That text is used to populate the body of a email message (MS Outlook). The HTML code is stored in the table as a string (nvarchar in the SQL back end).
Code:
<HTML><BODY><font color=black face="Arial" size=2><br><br><table border=1 cellpadding=3 cellspacing=0><font color=black face="Arial" size=2><font size=3 face="Arial"><b><tr bgcolor=lightblue>
<TD nowrap>FIELD1</TD><TD nowrap>FIELD2</TD><TD nowrap>FIELD3</TD><TD nowrap>FIELD4</TD><TD nowrap>FIELD5</TD></tr></b></font>
<tr><TD nowrap> DATA1 </TD><TD nowrap> DATA2</TD><TD nowrap> </TD><TD nowrap> DATA3</TD><TD nowrap> DATA4 </TD></tr></font></table><br><br> </BODY></HTML>
When it is placed into the email editor, the HTML tags show up correctly and the data is populated in a table.
I have built a form that is used to show the data stored in that table. But rather than have the HTML text show up as code on the form (with the tags, i.e. <tr> </tr>, etc. I'd like for it to show up like it does in the email.
I realize it shows up the way it does in the email message because of the Outlook editor. But I am wondering if MS Access (mdb and adp) has built in functionality that permit this type of view or if this can be done with vba.
I have read some articles about using ASP.net, but I am not sure how to do this. Just wondering if any of you have any suggestions or if you can point me to some resources on this.
thanks,
Ben