print a big recorset

I have a big recordset that retrieves many data from a few tables of my database.
When I select the first and last client of the client table from whom I wish to print invoices the program stops responding.
When I select just a few clients it prints allright.
I'm using a matrix printer and VB 6.0 with the print object.
Is the buffer of the printer to short for the amount of data?
Is the recordset to big?
Should I put those records in a temporary table and print each of a time instead of a recordset?

Who is Participating?
gcs001Connect With a Mentor Commented:
It could very well be that the printer's memory buffer is too small to handle large amounts of data at a time.

Try to use the Printer.EndDoc method more often to send the current data to the printer.

Also look at using the Doevents() function in your code while printing.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.