HTML tags displayed in table

[teel73]

I hope this is the right place for this question. My issue is simple to explain. When I copy data from Outlook or MS Word that contains bullets or other HTML formatted text, into MS Access text control, the HTML tags are displayed in the tables.

The memo field in the table is set to Rich Text and so is the text control on the form.

Below is an example of the data I'm copying from Outlook email:

1. 1. Fire Alarm Activation

• • • • Actual/Smoke Present
      • False
      • Planned Drill/Testing
      • Evacuation

2. Utilities/Power/Communication Failure

​

Now, below is what it looks like in my table or output in a report:

<ol>
<ol>
<li><strong>Fire Alarm Activation </strong></li>
</ol>
</ol>
<ul>
<ul>
<ul>
<ul>
<li>Actual/Smoke Present</li>
<li>False</li>
<li>Planned Drill/Testing</li>
<li>Evacuation</li>
</ul>
</ul>
</ul>
</ul>
<blockquote>
<div><strong>2.


How can I copy and paste and remove the html tags?

 

[MarkK]

The memo field in the table is set to Rich Text and so is the text control on the form.

Don't set the table field or text control to Rich Text. Then the tags will be dropped on paste.