I am trying to compare all fields in table1 to the corresponding fields in table2.
I have a query set up to match the tables on an ID field.
What I want to do is compare the fields in the report and formatting differences in the output. I think I need to use the Detail.Print or On.Format event - but not sure how to code it.
If field1 <> field2 then highlight background of field2.
Thanks for the help.