I am looking to autoformat Access reports almost exactly as discussed in thread703-1267819, except that I need the reports to print Tabloid (11" x 17") and Landscaped.
I am using the code shown in the thread but have changed the following values:
DM.intPaperSize = 17 '11 x 17 paper size - AKA Tabloid
DM.intOrientation = 2 'Landscaped
Otherwise, the code I have is identical to what was posted in the referenced post (thread). I am calling the module from the "OnClick" function of a button on a form, am passing the name of the report to the embedded function and can see that the module is getting called and quickly opening & closing the report in "design view". Unfortunately this does not alter the report's size when I immediately open it with the following command:
DoCmd.OpenReport "rptDetailedResults", acPreview
I verified that the paper size setting is correct. I am using Access 2007 on Windows XP.
If anyone has any ideas of what might be missing, I would very much appreciate your suggestions. Thank you.
I am using the code shown in the thread but have changed the following values:
DM.intPaperSize = 17 '11 x 17 paper size - AKA Tabloid
DM.intOrientation = 2 'Landscaped
Otherwise, the code I have is identical to what was posted in the referenced post (thread). I am calling the module from the "OnClick" function of a button on a form, am passing the name of the report to the embedded function and can see that the module is getting called and quickly opening & closing the report in "design view". Unfortunately this does not alter the report's size when I immediately open it with the following command:
DoCmd.OpenReport "rptDetailedResults", acPreview
I verified that the paper size setting is correct. I am using Access 2007 on Windows XP.
If anyone has any ideas of what might be missing, I would very much appreciate your suggestions. Thank you.
