Conditional Formating on Page break

[gyroJim]

Good Morning,
I have been finding great tips on this site for years, but I finally have a question that I can't find an answer for.

Is it possible to do conditional formating after a page break?

Background:
I have been given someone elses mess to clean up. It is a massive procedure which runs dozens of queries, then formats the results and pastes them into a word file at given bookmarks

For most tables there is one record for each lake. However there are several where many entries per lake. The logic being applied is that the font colour for the column is made white, then for each first instance of a lake name the font colour for that cell is made black again.

The problem is there are many times were the first row of data on a new page is not the first record for a particular lake making the reader have to flip back to the previous page to double check which lake they are looking at data for.

So what I want to do is leave the existing logic, and just add turning additional cell's (Column 1, after a page break) font colour back to black.

Any ideas on how to get a hanle on that cell would be extremely appreciated. At this point I'm willing to try unproven wild speculation based on anything remotely like this.

gJ

 

[David R]

That sounds AWFUL. Without giving an actual answer, would it be faster to just rewrite it as a series of Access reports??

 

[gyroJim]

That sounds AWFUL. Without giving an actual answer, would it be faster to just rewrite it as a series of Access reports??

It is actually quite terrifying. A "perfect" worst case exmaple of a single novice developer working on a big project without any input from others.

There is a lot of good things, don't get me wrong. The process does save the end user countless hours to produce the reports. Also some of his logic was very very clever. It is just the structure that is brutal.

I am very much in favor of a rewrite, but my marching orders are to fix it as it lies to the best extent possible, and my protests are falling on deaf ears.

This is the last issue.

 

[David R]

Can you post a stripped-down version of the database with dummy data in it? That might help someone give you answer (like I said, I have no idea how to proceed with that... is the page-break even determined in Access, or in Word?)