Is there a dynamic text option in Access?

Question

I extract data, using Access, from a database at work that has html code as part of the database. When the data extracts you can see the html code.  I was told to look for a "dynamic text option" for Access to display the data. I'm using Access 2010 but the database is from Access 2003. Is there any way to eliminate the html code from extracting?

Answer 1

define/describe "extracts"

Answer 2

The data gets extracted from the database via an ODBC link into Access.

Answer 3

Hi ruthiet,

>> Is there a dynamic text option in Access?

No, you could refer the link below for supported field type.

# Introduction to data types and field properties

https://support.office.com/en-us/article/Introduction-to-data-types-and-field-properties-30ad644f-946c-442e-8bd2-be067361987c

>> Is there any way to eliminate the html code from extracting?

Do you mean you want to remove the html tag from the data which you extracted from database? If so, there is no Access Object model to achieve this, and you need to check and replace the html tag with VBA.

Best Regards,

Edward

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 4

Do you know the vba code to achieve this? I couldn't get Format to work. I'm just learning how vba works. Thanks, Ruth

Answer 5

Perhaps they mean the "Rich Text" option rather than the "Dynamic Text" option?

Is the idea to *DISPLAY* the data without the tags, but formatted according to the tags?  Try the Rich Text setting of your textbox (Under the Data Tab in the property sheet, see the Text Format property).

Also, look at this article: 

Rich Text Fields

If you really want to *remove* the HTML tags, try the solution here:

Convert HTML to Plain Text

The 'references' mentioned in the solution are set through the VBA Editor's tool bar: 

- Tools --> References

- Check the desired reference

- Click OK to close the popup window and save

 

---

Miriam Bizup Access MVP

Answer 6

The rich text option worked in text of properties in Access but I had already made the suggested changes to the VB . I have to try the rich text option on another computer where I haven't made any other changes to see if that's the final solution. At any rate, im very happy at the moment. Thanks!

---

Ruth