Printing on 3x5 Rolodex Card Stock

[Guest]

Hello Everyone,

I have a report based on a query ( 2 tables: one is tblEmployee the other is
tblCars)

The query lists an employee with 1 to 6 cars (1 to Many relationship).

I have precut 3x5 card stock from Rolodex and have setup the report page
format to print 2 columns with 2 rows to match the cardstock.

I have been able to print an employee whether 1 or 6 on each card but not on
a single 3x5 card listing all the cars information line by line.

Now I have a Group Header (Height .75") for Name and phone number.

I want to list in the details section their year, make, and model on
separate lines.

I cannot get the report to go to the next section or more importantly next
card to print the next person and their respective cars.

The next person simply prints right after the last detail record, not onto
the next card.

I have played with the various properties but to no avail.

Can any one help.

- Tom

 

[SA]

Tom:

Make sure that you've got the paper size set properly File - > Page set up.
You may need to create a custom paper size in Windows to match your card
stock. This can be done by opening the printers folder and from the File ->
Server Properties menu item creating the new paper size then going back to
Access to select that size.

 

[Guest]

Steve,

First, thank you for replying. The Card Stock is on standard 8 1/2 x 11
paper. The Rolodex cards are laid out on the sheet 2 across and 2 down for a
total of 4 cards per sheet in landscape mode. In landscape mode both top and
bottom margins are 1 1/4" and left and right margins are 1/2". I did create
a "3x5 Card" custom within the Server Properties but that does not work for
the 8 1/2 x 11 sheets from Rolodex.

I did modify the GroupHeader... Properties... "New Row or Col" to "Before
Section" and that at least printed the top 2 cards in the first row
(landscape mode). It would be a terrible waste of paper as there are 246
total pages in the report.

Do you have any other Ideas?

- Tom