how to print blank rows in a report

fjp

New member
Local time
Today, 13:39
Joined
Jan 29, 2013
Messages
1
I have a report that will print a changing amount of records depending on the amount of items entered. The items are broken down by ItemNumber, Description, Make, Model and SerialNum. I take this db with me and enter in the items and then print the report. There are times when I need to add items to the report after it is printed and this is done by hand. So what I would like to print blank records on the report so that it will create the boxes for me to write in...I can fit 20 items per page. So if I go and pick up 3 items, I would like the report to print 17 more lines. This will make all of the reports uniform and leave me blanks to hand write additional items. Any ideas are greatly appricated...
Thank you.
 
Well, a way to do this would be to run your report from a temporary table and use VBA. So you would have to insert all of your report records into a temporary table and then count the number of records you have. If the number of records fall short of the 20 per page than you would need to insert the number of blank rows you are missing.
 

Users who are viewing this thread

Back
Top Bottom