Printing MSFlexgrid over multiple pages

[ExeCuteUK]

Hello,

Ive almost finished a project ive been working on, which involves taking in a fair bit of data into an msflexgrid control.

I then want to be able to print out this flexgrid along with some other information, which ive been able to do using the following :-

Printer.PaintPicture MSFlexGrid7.Picture, 800, 1300


I thought everything was fine untill today i found out i could have up to 30 entrys on this document. And as you can probably work out the paintpicture command just prints as far as it can to the end of the page then nothing else.

Ive been racking my brain today to try and work out how to get the program to either print up to a certain row then switch to a 2nd page or detect on its own when its approaching the end of the page and begin a 2nd page with the remaining contents, but so far ive not found anything.

Ive tried searching the net but havent really found anything which could help.

I dont mind changing the print process of the flexgrid if it allows me to print onto a second page.

If anyone can help i would be very gratefull.

Thanks!

PS (As a note this msflexgrid also contains VbCR in certain cells)

[RhinoBull]

You can calculate number of rows per page based on height of each row vs pahe height ...
However I would recomend to use logic similar to this to print content of your grid.
There are many other samples available on the net.

[ExeCuteUK]

RhinoBull, Thanks for your Response.

I have been trying something like that, which creates the grids, but because my grid contains a fair amount of VbCR characters it messes the entire print out, which is why I just used paint picture.