problems with print event and printer

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

Guest

I tried to add "empty" rows to a reports detail section by using the _print event in Access 2000.
I need this rows because each row comes with a frame. If they are empty the user can fill out the fields by hand later on the sheet.

Example:
Head: Title
Details:
-------------------------------
| data record 1 |
-------------------------------
| data record 2 |
--------------------------------
| no more data available: "empty" rows |
--------------------------------
| |
--------------------------------
...

With the format event I am able to add a constant number of"empty" rows.
In the screen preview the result looks correct but when I print it on my printer I get a different result. What is the reason for this ?
Is it possible to tell Access to automatically fill in "empty" rows till the page is completed ?

Many thanks for your help.
 
I copied this from an earlier posting: Hope this helps!
Fons
This problem is similar to creating a report that has a
fixed number of lines on a page, whether or not there is
data to fill those lines (e.g. a formatted orders
report.) If you look on our web, in the free files area,
there's a download called "Other Reports" which contains a
report that will fill a page with a specific number of
rows. Take a look at that; it will likely help you reach
your goal here.
--
Steve Arbaugh ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg
-----Original Message-----
I tried to add "empty" rows to a reports detail section
Click to expand...
by using the _print event in Access 2000.
I need this rows because each row comes with a frame. If
Click to expand...
they are empty the user can fill out the fields by hand
later on the sheet.
Example:
Head: Title
Details:
-------------------------------
| data record 1 |
-------------------------------
| data record 2 |
--------------------------------
| no more data available: "empty" rows |
--------------------------------
| |
--------------------------------
...

With the format event I am able to add a constant number of"empty" rows.
In the screen preview the result looks correct but when I
Click to expand...
print it on my printer I get a different result. What is
the reason for this ?
Is it possible to tell Access to automatically fill
Click to expand...
in "empty" rows till the page is completed ?
 
Back
Top