Need routine to set report to print on legal size for Access 2007

[sts125]

Found routines to set a report to legal size print on the Microsoft website. There is a version for Access 97, and one for Access 2000.

I am using Access 2007. I created a new module, and pasted the Access 2000 routine in. When I execute it, it dies at this line: rpt.PrtDevMode = strDevModeExtra then drops to an error trapping message.

Does anyone have a work around in Access 2007 to set a report to Legal size print?


Here is the knowledge base article...

Thanks

 

[sts125]

The routine actually works in 2007. It was where I was calling it from that was the problem. Putting it in the form load in my switchboard did the trick.