Access Report - Does Conditional Format work in HTML?

[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 "Report001" 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.

 

[misscrf]

I dont know if this will help, but I do understand that the memo field is the only field type that can do html. Not that that is the point, but I wonder if you did an IIF on an unbound memo field, and you could have your equation and the iif to include <b></b> for the purpose of the html print.

Does that make sense?

Let me know if you need me to explain my garbled thoughts.
lol

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[Tamrak]

Good afternoon misscrf,

Thank you for your response.

I have a few Conditional Format setup, such as highlighting the fields or bolding the characters when a specific condition is met.

When I exported to HTML, all of these formats disappeared, even a simpliest bold character. I could not tag <b> </b> because I have over 1,000 lines. Some lines meet the condition and some do not.

Look like I could not do anything on this one..

 

[misscrf]

that is why I suggested the IFF statement.

I dont know if it would work, but it might be worth a try.

=IIF [field]< (Date()), "<b>[field]</b>", [field])

you might try playing around with those quotes. I am thinking it will show the codes in preview, but once you print the html might pick it up.

just trying to find a way to make it work.

misscrf

It is never too late to become what you could have been ~ George Eliot