[AccessD] How to Prevent a button from being printed on areport.

Hi Brad --

Did you try to create an auxiliary transparent command button and to set focus to it after any of the other three of your command buttons get clicked?

Thank you.

-- Shamil


Sun, 8 Apr 2012 10:08:15 -0500 от "Brad Marks" <BradM at blackforestltd.com>:
> 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.
> 
> 
> 
>