Add blank records to fill page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

MS Access 2003 - I am creating a form to look like a pre-printed form that is
used in my office. The problem is, the pre-printed form has five sections to
enter item information. This works well when my report has five records (or
multiples of five) but if it only has two or three, then there is a blank
space where the pre-printed form has blocks for information. In the spaces
where there are records, the report looks exactly like the pre-printed form.
Is there a way to print extra blank records to make the report look like the
pre-printed form? It is very important since the command staff will not
accept the report if it doesn't look the same, even though it is so much
easier to click a button to do the report instead of filling out a
pre-printed form. I am able to copy and paste VBA code, and can tweak it to
suit my needs, but I am not a programmer.
 
It's difficult to make a suggestion when you mention "pre-printed form has
blocks for information" but don't tell us if these are created by grouping
and sorting, subreport, or what.
 
Very sorry....
The "block" is a continuous subform in the detail section of the report.
The original form has fields with 1pt borders and the name of the field
printed in small print in the top left of the block. There are several
fields for each record which fits together in a "block". Five blocks fit
perfectly on one page. I used the control's label to make the fields with
the 1pt border and placed the control inside the label's border. The report
also contains a page header and a page footer.
 
Are your subreports actually "subform" objects?
Is your objective to have each subreport fill exactly the same vertical
space and have lines for 5 records regardless of the number of records in
the subreport?
 
Yes, it is a subform object
---and---
Yes, that is my intention. Ideally, I would like for it to work with
multiples of five so that if the report has six records, the first and second
page will contain five records each with no blank spaces.

It absolutely blows my mind that you can understand what I'm trying to
explain when you don't have the advantage of seeing it. That's talent.
 
I would not use forms for printing. Consider changing the form to a
subreport. You can place the subreport on the main report and size it to 5
records or whatever. Add line controls to the main report as needed. These
should display through the subreport.
 
That works very well! But..... it will only print one page even if there are
more than five records. I currently have the subreport placed in the header
section of the main report - if I put it in the detail section, I get extra
pages - i.e. if there are three records, I will get three pages - each with
the three records. What might I be doing incorrectly?
 
I couldn't answer without creating some samples and playing around with it.
You stated "I currently have the subreport placed in the header section of
the main report" but don't state which header section. There are potentially
3 types of header sections.
 
I don't have a clue what you currently have or what you are attempting to
do. I am confused about why the subreport would be placed in a page header.
 
Back
Top