Results 1 to 9 of 9
  1. #1
    Join Date
    Apr 2004
    Posts
    77

    Unanswered: How to remove buttons from a printout!

    Hi there

    Pls I have a form that I print as a report.

    However when I print I do not want the save, addrecord etc buttons to show on the report.

    so far I have tried to change the properties of the display when to "screen only", however when I print the buttons are still showing.

    Can anyone pls tell me how to get rid of the butoons from not showing on my printout.

    Many Thanks.

  2. #2
    Join Date
    Apr 2004
    Location
    Sydney Australia
    Posts
    369
    When I print a form I have a macro placed on a label that opens, prints and closes another form that uses the same record source as my main forms or some other criteria might be used by the macro (s)

    An easy way to start is to make a copy of your form and then remove buttons/labels and change colour etc and this will be a form that you print.

    And don't forget that you can easily make a Report and print that from a macro or code that runs from OnClick on a label or button on your main form.

    Mike

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    You can make a copy of your Form but without these unnecessary buttons, this can be later be printed

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Quote Originally Posted by hammbakka
    You can make a copy of your Form but without these unnecessary buttons, this can be later be printed
    Well said, I would recommend using a report instead though.

    Give the user the option to "print form", but have it print a dummy report that takes a parameter instead.

    It will save you loads of headache, and the user will never know the difference.

    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  5. #5
    Join Date
    Oct 2003
    Location
    US
    Posts
    343
    Have another button on yuor form to print it. In its onclick event put this code
    Code:
        DoCmd.PrintOut
    MAke sure that the unnecessary button have their property set to "screen only"

  6. #6
    Join Date
    Apr 2004
    Posts
    77

    how not to show buttons on printout!

    Thanks guys for ur replys. information was very helpful

    Many Thanks

  7. #7
    Join Date
    Apr 2003
    Location
    Alabama, USA
    Posts
    154
    You can set the "Display When" property to "Screen Only". Go to each control's property window. It's under the Format tab.
    http://AccessDB.Info

    You live and learn. At any rate, you live. - Douglas Adams

  8. #8
    Join Date
    Apr 2003
    Location
    Alabama, USA
    Posts
    154
    Quote Originally Posted by khan
    MAke sure that the unnecessary button have their property set to "screen only"
    Oops! I missed Khan's answer!
    http://AccessDB.Info

    You live and learn. At any rate, you live. - Douglas Adams

  9. #9
    Join Date
    Apr 2004
    Posts
    77

    re print

    Many Thanks cosmos 75.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •