Print Button

[DREAMERMX]

Hi, I have a button on a FORM to print the current record with the following code:

DoCmd.RunCommand acCmdSelectRecord
DoCmd.PrintOut acSelection

But what I need is that before printing, open the preview to set the margins and page size ... or at least to pre-configure so that when you press the button, and comes preformatted

Thanks!

 

[ypma]

I use ac 2010 and use the Print preview option, if you have not tried it this is how:
With the form highlighted in the navigation column. Click File and then click Print and then select print preview ,
Hope this is of some us to you

 

[GinaWhipp]

While you can print the Form to get *control* over what you are printing use a Report. Then you can set it up any way you want and it will always print like that.