I am using Access97 and using the OutputTo command to export a report to a directory on my C drive. The problem I have is that the formatting of the lines on each page tend to get 'squashed' together which means that the report footer rides up the page, and therefore the report footer does not stay at the same level for each page (the no. of lines per page varies). However if I try and view the report from Access using the print preview option this formatting problem doesn't occur.

Any suggestions would be much appreciated.

Thanks,
Rodney.

Make sure all objects in your report have the Can Grow, Can Shirk properties set to Yes.

Thanks llkhoutx,

I have tried this but doesn't make any difference.

I wonder if it's formatting this way due to the fact that I have 4 sub reports and after each subreport I have placed a page break?

I have a report with 79 subreports and have to shrink all of the objects in each to .001 and and have the total subreport height very, very small, otherwise, the report is interspersed with blank lines which I can otherwise get rid of. An Access querk.