Results 1 to 4 of 4
  1. #1
    CS_10 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2014
    Location
    Derbyshire, UK
    Posts
    32

    Hiding buttons on Print of Report

    Hi there.
    I have a report that I view within the access database, and on the report are two buttons. Once to close the report and return to the main menu, and another to print the report.



    The print button is linked to a macro which just uses the PrintObject command. The close button also links to a macro and just closes the report, and opens a form.

    I was wondering if there is a way to hide both of these buttons on the print out?

    Many thanks.
    Craig

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    The button should have a "Display When" property.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    CS_10 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2014
    Location
    Derbyshire, UK
    Posts
    32
    Brill, just what I needed.

    Thanks for the help.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    No problem.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 6
    Last Post: 03-01-2014, 07:07 AM
  2. Hiding Command Buttons in Reports?
    By Rosier75 in forum Reports
    Replies: 8
    Last Post: 01-14-2013, 01:34 PM
  3. Showing/Hiding Navigation Buttons in VBA or Macro
    By chris.williams in forum Forms
    Replies: 3
    Last Post: 11-15-2011, 10:38 AM
  4. Command Buttons - Hiding/Unhiding
    By Hello World in forum Forms
    Replies: 4
    Last Post: 10-10-2011, 07:51 AM
  5. Replies: 0
    Last Post: 02-22-2011, 05:04 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