?
Solved

Access report export:  colors lost in HTML (and Word)

Posted on 2004-10-13
8
Medium Priority
?
747 Views
Last Modified: 2008-02-01
I have an Access2000 report with some colored text (the coloring is added via conditional formatting of a text box).  When I export the report to an HTML file, the colors are lost and the text comes out black.  How can I make the colors show up without post-processing the resulting HTML file?    Or, if it must be post-processed, any hints for how to do that would be appreciated (I've been trying to avoid VB/VBA in this project for a variety of reasons, but I'll bite the bullet if I have to in order to work around this "feature").

Using a different output format (e.g. PDF) is not an option for this appliacation; it has to be HTML (I tried using Word as an intermediate format, but the colors are lost when going to Word also, and it has other bad features as an intermediate format in this case anyway).

Thanks in advance for your help.
0
Comment
Question by:scottvandenberg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
8 Comments
 
LVL 4

Accepted Solution

by:
Gal_atea earned 1200 total points
ID: 12298814
I know you said that PDF was not an option, but what about using it as an intermediary instead of Word. As far as I know, when you Export none of the conditional or via code formats are kept, however if you print to PDF the formats are kept, and Acrobat has an option for save as HTML.
0
 
LVL 51

Expert Comment

by:Steve Bink
ID: 12299709
Here's one link you look at, though I'm not sure it relates directly to your problem:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209145

The article implies that a large part of report formatting will not carry over to an export.
0
 

Author Comment

by:scottvandenberg
ID: 12301945
Thanks for the suggestions so far.

Gal_atea, I just tried exporting (actually, you have to "print" it to a file) to PDF 6.0, then from PDF the "save as HTML" option.  Colors are preserved (this is good -- thanks for the suggestion!), but nearly all the formatting was lost (this is not good!).  To be perfectly clear:  the formatting was preserved in the translation from report to PDF, but lost in the translation from PDF to HTML.   I may have to just export it to HTML from Access and edit the HTML files to put the colors back in.  

Is this just how Adobe's HTML translator "works"?  Their documentation says little, but it seems like shabby behavior for software that isn't cheap.

If anyone can make further suggestions, I'd be grateful.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 51

Expert Comment

by:Steve Bink
ID: 12302315
Another option would be to create an ASP-style routine in VB to export the report manually.  Granted, this would be mega-coding, but you'd only have to do it once.  :)
0
 
LVL 4

Expert Comment

by:Gal_atea
ID: 12305885
Yeah, I guess Acrobat isn't designed to export to HTML, but to print, so it's probably an Acrobat issue. Sorry it's not going to work for you.
0
 

Author Comment

by:scottvandenberg
ID: 12320748
OK, so it seems like the proper solution to my question is to conver to PDF from Access, as suggested by Gal_atea (assuming one has Acrobat installed).  But to get it from PDF to HTML, Acrobat's PDF-to-HTML translation loses nearly all formatting and it looks horrible.  So instead, I tried a shareware (I think) program called PDF2HTML (from "verypdf.com"), and that preserved both color and formatting when translating PDF to HTML.

So, unless I hear other better ideas soon, I'd like to Accept the first half of Gal_atea's solution, but replace the second half with "get a real PDF to HTML converter instead of Adobe's".  This is my first post to this forum -- any suggestions how to accept part of a solution?  Should I split the points between Gal_atea and me?

Thanks again; I will wait until sometime next week to close this out.
0
 
LVL 51

Expert Comment

by:Steve Bink
ID: 12321079
I'd say award to Gal_atea since her solution led you to a workable method.  Your part of the answer will still be stored with the PAQ, so others who see it will know what happened.  If you would like to reduce the amount of points awarded for this question, you will need to post a request in the Community Support TA, available at this link:

http://www.experts-exchange.com/Community_Support/

If you would like to review the guidelines for grading and closing questions, here's the direct link to the appropriate help section.  Remove the "#hs5" if you want to see all the help topics.

http://www.experts-exchange.com/help.jsp#hs5

Good luck with the rest of your project!
0
 
LVL 4

Expert Comment

by:Gal_atea
ID: 12502162
Thanks for the points, scottvandenberg.

Gal_atea
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question