Print on Legal Paper- Everytime

[akaivyleaf]

I have some reports that must be printed on Legal Paper. Instead of having my user, go to File, Page Setup, Page, paper size, legal... is there a way I can automatically do this through code?

Please say yes, and explain to me how to do it.

Thanks

Sharon

 

[JerryDennison]

When you have the report open goto File... Page Setup... goto Page tab... change paper size to Legal... Click OK... Save the report.

 

[akaivyleaf]

That works just one time. When you close the database and reopen it, it reverts to letter size paper. I need this to be built in, for every user, every time.

 

[SteveR77]

Sharon,

What Jerry gave you should work because the reports infromation is a part of the saved MDB database file.

Make sure that you have a printer configured and selected as your default.
By allowing the report to assume printing to a default printer if the users are printing to different styles of printers the reports will still work because the database is using whatever the user has selected as a default printer.

HTH

Steve

 

[rafe]

Sharon,

Jerry & Steve are 100% correct!

BUT I too have had my report parameters "mysteriously" revert to the DB default. Who knows, I may be doing it in my sleep or maybe it's Ms. Gremlins ;-)

I've just started to look into the PrtMip & PrtDevMode properties of the report as a way to get/set/(make sure) report parameters are as they should be. I'm not an expert on these so I can't offer much help yet... but it's another angle for you to look into.

 

[akaivyleaf]

I tried it. It works for mine, sometimes. I have closed out of the database, shut down my computer and turned it back on, and now. . . it doesn't work. Nor does it work for my coworker.

 

[SteveR77]

As a bit of follow up to rafe's post...

Using the PrtDevMode Property to Verify Custom Page Size

http://support.microsoft.com/suppor...Mode&rnk=2&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

Again, I hope this helps...

B-) Steve

 

[braindead2]

One other thing to mention often people call a table or a Query a report. You can not save the print settings for a query or table. In order for it to be saved just create a report based on the table or query. If I am off base here please forgive me.

 

[akaivyleaf]

Thanks for the prtDevMode Property. I will try that. . . I will let you know how this comes out. Anybody had success with this?

 

[embryo]

I realize this is several years later, but from the Tools Menu, choose Options...then choose the General Tab and specify what you want ALL reports default margins and layout to be-

Steve
---------------------------------------
IF WebApplicationProgrammer = True Then
ElectronicSheepHerder = True
End If