Brad Marks
BradM at blackforestltd.com
Sun Apr 8 10:08:15 CDT 2012
Rocky, Thanks for the help. I didn't fully explain things. The report is being opened in "Report View" (Access 2007/2010). The buttons that control the color of the headings are pushed after the report is already opened (the buttons are actually on the report itself). They enable the users to change colors "on the fly", once they see the report on the screen. They need to look at the report before they decide to print it or not. Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com on behalf of Rocky Smolin Sent: Sun 4/8/2012 10:00 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] How to Prevent a button from being printed on areport. In the open event of the report can you just see which button is pushed (maybe make it an option frame - then you'd have a value of 1, 2, or 3). Then change the color of the heading or border or some other control on the report to the appropriate color? Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Sunday, April 08, 2012 7:40 AM To: Access Developers discussion and problem solving Subject: [AccessD] How to Prevent a button from being printed on a report. All, We have an Access Report that has three buttons near the top of the report. The purpose of these buttons is to change the color of the report header section to green, blue, or yellow. The different colors are used to differentiate between the "Accounting Copy", the "File Copy" and the "Production Copy". This approach is being implemented to replace an older method of using different colored paper. The users love this new approach because they can simply print the report on plain white paper and no longer need to load different colored paper into their printers. We are seeing one small glitch that I would like to better understand and to resolve. The "Display When" property is set to "Screen Only" for the three buttons. However, if a user clicks on one of the buttons and then prints the report (Via the round Office Button in the upper left corner of the screen) the color button that was pushed is printed on the report. We have found that if the user clicks on another place on the report (outside of the color button), then the button is not printed on the report. I believe that this is related to the button "having focus", but I can't understand why it would still have focus after the Office button is pushed and "Print" is selected. One more little tidbit. Development is currently being done with Access 2007, and deployment is on Access 2010. I am not sure if this makes a difference or not. Thanks, Brad -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.