By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,917 Members | 1,313 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,917 IT Pros & Developers. It's quick & easy.

Printing help continuous form

P: 1
so printing a report that is based off a form.

it prints the correct form with the correct information, then after that on the same sheet of paper it will print an empty form with all the lables but no information.

I talked with a friend and he suggested the form had continuous selected as an option is the reason im getting a second empty form printed.

I cannot find this anywhere int he properties for either the report or the form it is pulling from.

another thing ive been working with is the code for this program i am editing is:
Expand|Select|Wrap|Line Numbers
  1. MsgBox Err.Number, vbOKOnly, "Error Number:" & Err.Number & "; Description: " & Err.Description
  2. DoCmd.SelectObject acReport, "Pass_Zone2", True
  3. DoCmd.PrintOut acSelection, 1, 1
  4. DoCmd.SelectObject acForm, MyForm.Name, False
I have tried messing with the acSelection,1,1 by editing it out and seting the different values that it prints from and having got it working except for printing a third empty form.

Any ideas on how to fix this would be helpful. its not a life or death problem but its annoying that its doing this, the second form doesnt show up on print preview.

EDIT: i checked if it was continuous and it isnt, the form the report is pulling from is single in default view, and the report is print view as default view
May 1 '10 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,492
I admit to finding the question somewhat confusing with all the references to forms while dealing with a report.

As for your PrintOut method, I don't use it myself, but context-sensitive help (Select word & press F1) will give you good information on how to use it correctly. There shouldn't need to be any experimenting at that level I wouldn't have thought.
May 2 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.