Printing help continuous form

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • knifeyhead
    New Member
    • May 2010
    • 1

    #1

    Printing help continuous form

    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:
    Code:
    MsgBox Err.Number, vbOKOnly, "Error Number:" & Err.Number & "; Description: " & Err.Description
    DoCmd.SelectObject acReport, "Pass_Zone2", True
    DoCmd.PrintOut acSelection, 1, 1
    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
    Last edited by NeoPa; May 2 '10, 01:17 PM. Reason: Please use the [CODE] tags provided
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32669

    #2
    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.

    Comment

    Working...