How can I make a standarized report?

[caracena]

Hello all,

I'm having problems trying to find a way to make a report that allways have the same logitude (fills the hole page from top to bottom). What I want to acchieve, is a report that no matter how many items are collected from the tables (1 ~ 20), the final report shows a standarized page.

Botoom line, is there a way to make Access fill the rest of the rows (2 ~20) with blank information?

Thanks a lot in advanced,

 

[statsman]

Not as such. However, if you have data that you want to appear at the same place on every page, you can place it in the page footer and set the top margin of the page footer so that it always comes out the same on every page.

 

[gemma-the-husky]

if you want every record on a separate page, just put a force new page after in the formatting for the detail section

 

[caracena]

Thanks guys but actually, what I want to achieve is something else. Lemme try and explain it again:

I have a report that prints an invoice. That invoice can have 1, 2, 3 items or more, each having quantity, description, part number, unit price and total price (1 item per row). The report fetches the data (line by line) from a table and prints x quantity or rows, depending on how many items are to be invoiced (how many different items the customer bought).

Now, each column is separated from each other by a single vertical line, which has the same altitude as the row itself, making thin-uninterrupted lines that separates each column.

Ok so far so good, except that right after the last item invoiced, a thick horizontal line appears which is followed by the sub-total, shipping & handling and grand total boxes, that shows the total to be paid (sounds like an ordinary invoice right?).

What I want to get, is more rows with just the vertical separators, no matter if the customer only bought 1 item, so the bottom boxes (the ones that show the total and stuff), are always placed in the same position.

Think on a printed blank invoice that you need to fill by hand... in the items section, you start filling line by line according to the products you need to charge your client for... it always have the same format, no matter if you only invoice 1 item and leave like 10 inches of page blank... you following me?

I've found a way to cheat this and that is... by adding blank rows to that invoice's table so that it "prints" blank items. I've found that I need to have 32 items to have the exact format I want... the thing is that I don't wan't my "items" table to be filled with blank rows... imagine after 100-1 item-invoices, I would have a 3.200 rows table!!!!!!

Is there a way of telling Access to "invent" those "blank rows" for me or something like that? I know it should be "kinda" easy for someone with lots of coding experience

Thanks a lot again!!!