Conditional Formatting in Access 2002 Reports

Hi,

I’m having a problem with conditional formatting in a report in Access 2002.

The report has been set up with conditional formatting using the Format -> Contitional Formatting menu AND through manually coding it in the Detail_Format sub routine for the report itself.

Both formatting types work perfectly fine if I run the code to display the report from a form (or simply open the report and preview/print it).
However, if I try and run the report using a macro all of the conditional formatting disappears! I am about to test to see if there is possibly something else I am doing in the code the macro runs that might cause this, but at the moment I am at a complete loss!

Does anyone please have any suggestions?