Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2006
    Posts
    17

    Report Prints Out Before Previewing

    I created a dialog box that generates a report (based on a query) after
    selecting from the combo box and clicking the OK button. However, the report
    goes straight to the printer instead of displaying on the screen.

    How can I get the report to preview first, with the option to print it or
    close it?



    Would greatly appreciate help! (thank you)----

  2. #2
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Posts
    99
    DoCmd.OpenReport "My Report", A_PREVIEW

  3. #3
    Join Date
    Mar 2006
    Posts
    17
    Right on the money John!!

    I pasted A_PREVIEW in place of what was already there which was:
    acViewNormal, acEdit

    What part of that code was sending it to the printer?

    Also, since I don't imagine a functional 'print' button can be placed onto the report, can I create another dialog box with a 'print' button, and link it to the OnOpen event of the report?

    Thanks loads again!!!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 10-24-2008, 11:20 AM
  2. report prints blank page at end of report
    By darrellx in forum Forms
    Replies: 0
    Last Post: 03-14-2006, 08:51 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums