Results 1 to 7 of 7
  1. #1
    Robert2150 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2013
    Location
    Sparks, Nv
    Posts
    104

    How do you View an Access Report before printing it?

    I have an Access program that prints various reports with a button.

    I would like to view the report in full screen prior to printing, how do you do this?

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,848
    Did you try Print Preview?

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,630
    VBA code:
    DoCmd.OpenReport "report name", acViewPreview

    Macro has equivalent.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    Robert2150 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2013
    Location
    Sparks, Nv
    Posts
    104
    Yes, however the report opens behind My Main Form, which contains the button, that contains the event, how do I get the report to display on top?

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,630
    Is the form set as Popup?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    Robert2150 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2013
    Location
    Sparks, Nv
    Posts
    104
    Yes, the form is set as Popup.

  7. #7
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,630
    Don't and then see what happens.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Printing a report from form in view
    By keiath in forum Reports
    Replies: 24
    Last Post: 04-04-2014, 09:26 AM
  2. Changing field value in report view in access
    By tanyapeila in forum Queries
    Replies: 2
    Last Post: 03-17-2014, 01:31 PM
  3. Replies: 1
    Last Post: 03-08-2013, 03:05 PM
  4. Replies: 4
    Last Post: 01-08-2013, 04:14 AM
  5. Printing report crashes access
    By romebrown in forum Reports
    Replies: 2
    Last Post: 11-23-2011, 10:30 AM

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