Reports Problem

Hi Folks,

I need some help. I am hoping the regulars at this forum can help me. I tried my post in another forum and the answer I got was not to my satisfaction, so I am looking for another perspective on fixing this.

Here is the situation. End user wants to prints all reports from a table. I set it up to send all records to printer. Problem is if record needs two pages, another record may overlap. Another words, record 1 requires 1 page, record 2 requires 2 pages.....BUT record 3 decides its gonna jump in and print on record 2 page 2. Weird? Here is the simple code that sends this off:

DoCmd.OpenReport "CSEvaluation_PrintAll", acNormal, , "Department='Mill'"

What I am thinking is there any way to pause between printing records. It seems like its processing this too fast.

Now just to answer a question someone may ask, if I print the records out individually no problems. Just when I print all at once. As far as the opinions I disagree with, some other guys thought a page break is what I needed. I don't agree. Thanks!

Does it do the same in Preview mode?