Printing Report with Set Number of Blank Rows

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I have a report that prints out the member header info (Name, Addy, etc) and
under are rows to allow member to enter a list of employees. We don't
track employees only the number that a member company has employed.
The number of employees can range from 5 to 50. I save the number in my
member info table.
I would like Access to print the same number of rows as employees, a small
comp. might have 1 page another comp. might have 3 pages. Does anyone have
any suggestions on how i could do this????

thanks
rob
 
You can use the OnFormat, OnPrint and OnRetreat events of each section of
your report to achieve that; however, the near total lack of documention and
examples on this topic make these events very hard to use.

A much more easy way would be to store your results in a intermediary table
and then to add the required number of empty rows with a small VBA
procedure.

You can also create a matrice table with sequential numbers from 1 to a
number greater than any number of employees (1000 for example) and this use
this table to create the empty rows with a join between the number of
employees and the matrice table. However, it's probably a little more
complicated to achieve than to write a VBA procedure for adding empty rows
to an intermediary table.

S. L.
 
Back
Top