Printing problem - Access XP

[Newbie]

I have a report that prints to a Dot Matrix Printer on a label that is 19cm
w x 7cm h
I have set this up and when you look at the report in design mode the page
looks as though it is the same as the form
However when I print it each record appears to be 3 pages long even though
all the data is on page 1

I have set the printer to be "use specific printer" with the correct
papersize

What am I doing wrong or does anyone know of any know problems

Thanks

A

 

[Wayne Morgan]

Have you set the Headers and Footers to zero height? What is the height of the Detail
section? Double click the bar that says "Detail" to open the Properties sheet if it isn't
yet and go to the Format tab of the Properties sheet. What is the Height value?

 

[Newbie]

Yes headers and footers are 0 and the height of the detail section is 7cm

I am printing the report using the code:
DoCmd.PrintOut , , , acLow, 2, 0

What is happening is that 2 copies print out ok for each record but
inbetween each different record it feeds 6 extra pages.

Any ideas?

 

[Wayne Morgan]

In that case I would try a different printer as a test to see if the problem is the
printer/driver or the report.

 

[Wayne Morgan]

What size page are you trying to set it to? How many labels are there per "sheet"?