Software

Ask something
Question Locked

Conditional Formatting in Access 2002 Reports

0 helpful
2 replies

by rdoumouras

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

2 replies

by rdoumouras

It's ok I finally worked it out. The conditional formatting was relying on the input of values into set parameters that were not being populated by the macro - problem solved!

This discussion is closed to new replies.