Solved

Changing printing orientaion in runtime

Posted on 2003-11-06
6
312 Views
Last Modified: 2010-05-03
Hi,
I'm using VB6 with access97,
I created a report and I want to print it.
The report width is larger than the paper width,
How can I change the printer's settings from my code, inorder
to change the paper orientation to landscape (during runtime only) ??
Thanx a lot!

0
Comment
Question by:zolpo
  • 3
  • 2
6 Comments
 
LVL 28

Expert Comment

by:vinnyd79
Comment Utility
Have you tried:

Printer.Orientation = vbPRORLandscape
0
 
LVL 1

Author Comment

by:zolpo
Comment Utility
Hi,
I tried this, but it didnt work
Thanks
0
 
LVL 28

Expert Comment

by:vinnyd79
Comment Utility
Can you post the code you are using to print?
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 1

Author Comment

by:zolpo
Comment Utility
Hi,

myReport.Show
This is the code that shows the report (simple as that), if my printer's orientation setting are not set
to landscape the report wont show, and I get an error that the report's
width is too large,
When the report is displayed there's a button that allows to print it, and this is
what i'm using to print the report,
( before I used
myReport.PrintReport True, rptRangeAllPages,
but I dont need this,)
thanks,
0
 
LVL 5

Accepted Solution

by:
fantasy1001 earned 125 total points
Comment Utility
0
 
LVL 1

Author Comment

by:zolpo
Comment Utility
fantasy Thanx a lot!
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now