Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2024
    Posts
    4

    Export to HTML Document

    I have a simple table of about 4,700 records with each record having only an ID plus 3 fields.




    It's common to periodically add new records and then, once added, to export the table as an HTML document. This has worked fine for the past 2 years. Since this past Monday however, the exported file uses HTML decimal codes for each character instead of regular ASCII characters. Here's a before Monday and since Monday example:


    Before Monday: <TD>00-001</TD>
    Since Monday: <TD>00-001</TD>


    I've tried it on a computer with Access for Microsoft 365 MSO (Version 2403 Build 16.0.17425.20124) 32-bit installed. I've also tried it on another computer with Access for Microsoft 365 MSO (Version 2403 Build 16.0.17425.20176) 64-bit installed. Same result on both.


    Nothing I've researched so far leads me to why this is now happening or how it can be fixed.

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    ??? Perhaps I'm missing something obvious--BUT -Did you quote the wrong example? Please explain exactly what discrepancy/error you are experiencing.

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,945
    They look identical to me?
    Any windows/office updates recently?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  4. #4
    Join Date
    Apr 2024
    Posts
    4
    Yes they both look the same. I'll try an image instead:



    Sorry for the confusion.

  5. #5
    Join Date
    Apr 2024
    Posts
    4
    And I guess the image didn't work either. I'll try this:

    Before Monday: 00-001
    After Monday: 00-001

    You can see I'm new at posting.

  6. #6
    Join Date
    Apr 2024
    Posts
    4
    Nope, that didn't work either. Embarrassing!

    Try this, the decimal equivalent of the ASCII characters, so instead of 00-001 it's 48 48 45 48 48 49. I'm leaving out the &# before each number and the semi-colon after the number.

  7. #7
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,803
    FWIW, usually, using code tags eliminates issues that forum software causes. Next time try tags (# button on posting toolbar). Going "Advanced" and using preview is often helpful. Also, you can't paste pics or files here. See "how to attach files" at top of page.
    Code:
    instead of 00-001 it's #48;#48;#45;#48;#48;#49
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How can I convert a Word document to HTML email (VBA)
    By SidCharming in forum Programming
    Replies: 9
    Last Post: 08-03-2018, 02:10 AM
  2. Export to HTML
    By Thompyt in forum Programming
    Replies: 5
    Last Post: 03-03-2017, 10:48 AM
  3. Replies: 5
    Last Post: 07-31-2012, 06:15 PM
  4. Export to html AccessTemplate tags
    By starhawk85 in forum Import/Export Data
    Replies: 1
    Last Post: 04-30-2012, 10:30 AM
  5. Best approach to export to HTML in this scenario
    By techguy817 in forum Import/Export Data
    Replies: 0
    Last Post: 04-17-2009, 10:28 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums