Access 2010 report orientation problem

[rmal30005]

Just got a new laptop and went from Access 2007 running on Windows XP Professional to Access 2010 running on Windows 7 service pack 1.
I transferred an Access database file I created on the old platform to the new platform and now have the following problem (none of the objects within this database file were touched -- the file was simply copied from the old to the new machine)...
I have several reports that were created to run and print in Landscape orientation. I either open these reports directly, or I invoke them using the EmailDatabaseObject action within a macro. On the old platform, the output was the intended landscape orientation. On the new platform, it still comes up landscape when the report is run directly, but when I invoke the identical report through the macro (using output type snapshot), the result is in portrait mode (same report object -- I promise). I created a fresh report within Access 2010 to reproduce this and it is easily reproducible. Create any report and make the orientation Landscape. Save it. Open and print it -- no problem. But, create a macro with one step, EmailDatabaseObject, reference the report and choose snapshot format as the output. Report will only come up in portrait mode. Definitely a bug. Has anybody seen this or have an thoughts about how to resolve it?

 

[JHB]

The problem is described here - and so it is, I've tried it my self:
http://www.office-archive.com/13-ms-access/39bc66b0f9cfebee.htm
look at post #3/#3
Below the text from the solution:

The problem relates to the printer setup on each workstation - when the
report senses that the default printer has changed, it reverts to the
default paper size for the new default printer. (Thanks a bunch
Microsoft). I finally solved the problem by creating a printer called
"Access Legal" on each workstation (pointing to the closest network printer
for each user), set the default paper size on that printer to legal and
then print the report to a specific printer called "Access Legal".

Harley Arnett

 

[rmal30005]

Thanks very much for your reply. Yes, that is a problem. In my case, however, I have gotten further along and now think I have a simpler explanation and a fix. If you migrate from Access 2007 to 2010, and if you have a macro that used the SendObject action, Access is going to change that automatically to EmailDatabaseObject. But, the macro also has an output format parameter, and mine were set to Snapshot format. In Access 2010, Snapshot format is no longer supported, but pdf format is. That makes good sense since mostly everyone has a pdf viewer on their computer, but Snapshot viewing often required a Microsoft patch. But the conversion from 2007 to 2010 didn't change the output format from Sanpshot to PDF. When I changed that manually, all the reports work fine.
Thank you again for posting your reply, and also to anybody else who put some time and thought into this.