How to Set up OCR character in Report Header based on Report Length

[jdbass]

I have a report that will print for multiple customers. If the customers have too many records, their report will go to 2 or more pages.

Example:
Overall report is 4 pages.
Customer 1 - 1 page
Customer 2 - 1 page
Customer 3 - 2 pages

The 4 page report gets sent to an OCR device for auto stuffing into envelopes, so I need to do the following:

Customer 1, Page 1 Header has "====" in upper right corner
Customer 2, Page 1 Header has "====" in upper right corner
Customer 3, Page 1 Header has " " in upper right corner
Customer 3, Page 2 Header has "====" in upper right corner

This report can be 1000's of pages long, and nobody wants to hand collate these.

Any ideas on how to make this work?

 

[hermanlaksko]

On the report:

Private Sub Report_Page()
If Me.Page Mod 4 Then "Your OCR code"
End Sub

Just a suggestion

Herman
Say no to macros