Lost Conditional Formatting when exported to HTML

T

Tamrak

Good afternoon,

I have some difficulties on getting an output of the report. I have a report
created in Access with a conditional format set on one field (out of 15
fields. Let's say the report name is "Rpt_Task" and the field name is
"Completed_Date".

I set a conditional format in the report that if the Completed_Date is less
than today (Date()), bold the whole field, otherwise, just display everything
regularly. It is working fine when the Output is in Access or Snapshot format.

When I wrote a macro by sending a command to produce an HTML file, all
characters remain the same. The output does not bold some of the records. I
tried several times but it still produces the same result, normal characters.

What should be a fix on this issue? I am unsure whether I need to write a
code in VBA since the regular Access Report output is looking fine.

All comments are welcome. Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top