Printing Problem

I need to make modification on a system that has been developed another programmer. The problem of this system is that, when u do printing, the data that's been printed out change its font size so that all the info will be fit into one page.

For example if there are 200 lines to be print, all the 200 lines will be fit into 1 page, making the size of the font shrinks so small that u can't even read.

I've check the coding if there is any command that set the printing to be in 1 page but can't find any. The data is printed out using Ms Excel format....for the page header...then there are codes in VB for inserting new lines for the detail part.

Can anyone help me out with this? I am having a headache.........

OK now the font size problem is solved, but another problem occurs:

There are 50 lines for each specification texts and the instruction texts,
The instruction texts print out all 50 lines OK but the specification texts only prints out until the 49th line. The setting for specification and instruction text are the same but the "get specification text" command and the "get instruction text" command are slightly different.

i've check for any codes that specify the print out to be until certain limit but could not find one in either of these command.

can anyone help?

How can U Slave the "font size problem"??