none
Is there a dynamic text option in Access? RRS feed

  • 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?
    Tuesday, February 9, 2016 8:56 PM

Answers

  • 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

    Wednesday, February 10, 2016 10:33 AM

All replies

  • define/describe "extracts"
    Tuesday, February 9, 2016 9:49 PM
  • The data gets extracted from the database via an ODBC link into Access.
    Tuesday, February 9, 2016 10:02 PM
  • 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.


    Wednesday, February 10, 2016 3:29 AM
  • 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
    Wednesday, February 10, 2016 8:55 AM
  • 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

    Wednesday, February 10, 2016 10:33 AM
  • 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

    Tuesday, February 23, 2016 9:21 AM