By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 1,001 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

Data Access Page Orientation

P: 3
Hi Guys,

This should be quite simple but my brains are being seriously racked.

I have created a data access page as the report I want to generate is 4 pages (too long for a regular report). Access page looks good and works well with my query. The problem is, it will only print off in landscape regardless of how many times I change it to portrait. I have edited it both in Access and Frontpage by editing the actual html document. I have shrinked the width of the text to make it well within portrait page size.

Using Access 2002 on XP which is on a regular network.

Any help would be much appreciated. It an't be that difficult can it?

Cheers
Sep 3 '07 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,669
Hi Guys,

This should be quite simple but my brains are being seriously racked.

I have created a data access page as the report I want to generate is 4 pages (too long for a regular report). Access page looks good and works well with my query. The problem is, it will only print off in landscape regardless of how many times I change it to portrait. I have edited it both in Access and Frontpage by editing the actual html document. I have shrinked the width of the text to make it well within portrait page size.

Using Access 2002 on XP which is on a regular network.

Any help would be much appreciated. It an't be that difficult can it?

Cheers
Try executing the following line of code before Printing the Page:
Expand|Select|Wrap|Line Numbers
  1. Application.Printer.Orientation = acPRORPortrait
Sep 9 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.