Access printing report footer at bottom of page

[beamerman]

I am using Access 97 to print invoices. The invoice is printed imediatly after the invoice is created. This means that there is only 1 invoice per print. I use the report footer to display grand total and other invoice information. My problem is that the footer prints directly after the last line. Is there any way that i can get it to print at the bottom of the page. I usually use Crystal and you can format the section to print at the bottom of the page... I just can't find a similar option in Access.

Thanks in advance.

Shane

 

[JerryDennison]

Have you tried just moving the report footer controls to the Page footer?

 

[beamerman]

Thanks. I thought about that, but it is possible to have more than one page per invoice

 

[JerryDennison]

There are a couple of ways around this. One is to determine the number of pages at run time and hide the values in the footer of the first page. Another is to use the Report footer section but count the number of lines left on that page and backfill with blank lines for force the footer to the bottom of the page. Either way will require code. If there is another way I'm not aware of it.

 

[beamerman]

Thanks Jerry, i'll give that a try