View Single Post
  #3  
Old May 10th, 2005, 05:18 PM
external usenet poster
 
Posts: n/a
Default

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
"SA" wrote in message
...
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.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

Tom T wrote in message ...
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