Problem printing a report in MS Access?

Question

I have a report in my MS Access contacts database, which filters out just the people that I want to send Xmas cards to. I have a button on my switchboard that I want to be able to click and print the labels. Here is my problem:
Linked to the button is the following (two line) macro:
OpenReport (Report Name: "rpt Xmas Card Labels", View: "Print")
PrintOut (Print Range: "All", Copies: "1")
However, whenever I run the macro, I get a printout of the correct labels, followed by a printout of the entire switchboard. Even if I insert an extra line at the beginning of the macro to close the switchboard, it still prints out the entire switchboard after the labels. I have tried using "Select Object" to specify which form to print, and then it prints the labels, but ends with an error, saying that the object it is trying to print isn't open. Surely this must be a simple enough task! If anyone can point out what I am missing, I'd be grateful. Thanks.

Answer 1

You might get your answer here

http://experts.about.com/q/Using-MS-Access-1440/Printing-problem-form-1.htm

Answer 2

MS get entry to checklist Printing? stupid concept yet have you ever adjusted the component top? There could desire to be no extra beneficial area below the backside placed administration interior the component section which will seem to have an extra line! attempt dragging the backside of the component line up or perhaps over the full information section even over the controls it is going to bounce all the way down to the backside placed administration. this could even show a sparkling (or what seems to be a hidden administration too if it settles under you anticipate). without sending the checklist layout (with the aid of itself), i won't be able to help you fur her. Ben Beitler

Answer 3

it isn' t the macro that you need to look at it is what the query is pulling from the table that will need to be altered