Report printing Problem

[GSR]

I have an access report which prints expenses for each employee for a specified period. The report is approximately 100 pages long with one page per employee. The report is produced in alphabatical order.

For some reason the report used to stop printing at letter 'L', now it goes upto letter 'R' and stops printing.

Sometimes I get the following message printed at the end in a blank new sheet.

ERROR: syntaxerror
OFFENDING COMMAND:
STACK:

Would appreciate any advice/help.

Thanks

GSR

 

[jtvcs]

I had a similar problem to this a few years back in Access 97. Could only narrow it down to a specific printer and it's low memory capability. Changed the report to print only portions of the alphabet (e.g. A thru G, etc.) then ran the three reports that were used to complete the set (then through a macro) but today would probably use VBA. HTH JT