Setting up for Printings

[dakota81]

For some forms in an application I'm buiding, it is just easiest for us to print the form straight-out. However, there are certain changes that need to happen before printing: change background color to white, set page to landscape, make page magins narrower. Is there a way I can automatically perform these changes so that the print-out will fit a single page and not waste a lot of ink?

 

[Aivars]

Hi!

Open the report in preview, push <Page Setup> on Menu Bar and make needed changes. Best solution for it is to create custom menu bar.
Aivars

 

[dakota81]

Is there way to automatically do these tasks, like through a macro or vb code? Especially I want to get the background color changed to white when printing.

 

[pflangan]

add a custom print button, either to your form or a menu bar, and then set the code of whatever controls you like in vba. set them back when finished.


Me.Detail.BackColor = RGB(255, 255, 255)
DoCmd.RunCommand acCmdPrint
Me.Detail.BackColor = 0

all done ;-)