report that automatically provides blank lines to equal 1 page

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

Guest

I want to create a report that returns information from the data base, ie: an
accountability form that would include a list of products or invoices, but
completes the page automatically with blank lines , Up and to the end of the
page. I can create a report with blank lines, but sometimes it goes over or
under 1 page depending on the data being reported.
 
I want to create a report that returns information from the data base, ie: an
accountability form that would include a list of products or invoices, but
completes the page automatically with blank lines , Up and to the end of the
page. I can create a report with blank lines, but sometimes it goes over or
under 1 page depending on the data being reported.
Click to expand...


I recently cited this for another post. I have code that will do this for you.
You'll have to modify it to meet your needs, and the file is in Access 97
format, but it can be upsized.


http://amazecreations.com/datafast/downloads/AdmnCodes.zip


Basically, the solution is to do advance the print location after printing
the last record and reprint the last record as many times as needed to
create the empty boxes. However, you toggle the font color to WHITE.
Cool trick, huh? Printing the last record with white ink, so to speak,
leaves an empty box.
--


Danny J. Lesandrini
(e-mail address removed)
http://amazecreations.com/datafast
Danny J. Lesandrini
(e-mail address removed)
http://amazecreations.com/datafast/
 
Back
Top