Printing multiple copies per page

[Guest]

I have designed a progress report card on an unbound form such that it takes
up 1/2 of an 8.5 x 11 inch piece of paper when printed.

So that teachers can have one copy to hand to the student and one to keep, I
would like to instruct a command button to print two copies of the form per
page, one atop the other. I'm not sure how to code it so this happens. (Or
even if it's possible!)

Thank you in advance for any suggestions.

 

[John Vinson]

I have designed a progress report card on an unbound form such that it takes
up 1/2 of an 8.5 x 11 inch piece of paper when printed.

So that teachers can have one copy to hand to the student and one to keep, I
would like to instruct a command button to print two copies of the form per
page, one atop the other. I'm not sure how to code it so this happens. (Or
even if it's possible!)

Thank you in advance for any suggestions.

Use a Report for printing, not a Form. You can set the size to 6.5 x
4.5 (with one inch margins) and it will indeed print two per page.

If you're (unwisely) using a Form to lay out a printed report, rather
than storing data in a Table and printing that, you can still use a
report - set its Textboxes' control sources to

=Forms!YourForm!Textboxname


John W. Vinson[MVP]

 

[Guest]

Thank you for your response John.

Yes, I do intend, of course, to have the data the form collects saved back
to a table, but the form itself has been designed to imitate a paper report
teachers have been using. I just wondered if there was a way I could use VBA
code on the print event to specify two copies per page.
--
BJM
ACE Assistant
Gary Allan High School

 

[John Vinson]

I just wondered if there was a way I could use VBA
code on the print event to specify two copies per page.

Maybe, but not that I know of.

It's easy to save a Form as a Report though - keep the same layout and
formatting.

John W. Vinson[MVP]