?
Solved

Runtime error on Papersize 11x17

Posted on 2000-04-24
4
Medium Priority
?
220 Views
Last Modified: 2008-03-17
I am trying to print a Flexgrid and set the Papersize to 11x17.  When ever I do it gives me Runtime Error 380(Invalid Property Value).  This is trying to print to a HP 8000 PS Laserjet which has 11x17 in tray 3.  The grid will print on Legal and 8 1/2 x 11.  How do I get it to take the 11x17 papersize?  I have tried setting the value in both numeric and text.  Neither works.  
0
Comment
Question by:kburg
  • 2
  • 2
4 Comments
 
LVL 6

Accepted Solution

by:
DrDelphi earned 100 total points
ID: 2744473
I suspect that the printer may support a papersize of 11 x 17, but not all of that is printable. Try using GetDeviceCaps on the printer, reading
PhysicalHeight, PhysicalWidth, etc....
from the win32API help file:


PHYSICALWIDTH      For printing devices: the width of the physical page, in device units. For example, a printer set to print at 600 dpi on 8.5"x11" paper has a physical width value of 5100 device units. Note that the physical page is almost always greater than the printable area of the page, and never smaller.
PHYSICALHEIGHT      For printing devices: the height of the physical page, in device units. For example, a printer set to print at 600 dpi on 8.5"x11" paper has a physical height value of 6600 device units. Note that the physical page is almost always greater than the printable area of the page, and never smaller.
PHYSICALOFFSETX      For printing devices: the distance  from the left edge of the physical page to the left edge of the printable area, in device units. For example, a printer set to print at 600 dpi on 8.5"x11" paper, that cannot print on the leftmost 0.25" of paper, has a horizontal physical offset of 150 device units.
PHYSICALOFFSETY      For printing devices: the distance  from the top edge of the physical page to the top edge of the printable area, in device units. For example, a printer set to print at 600 dpi on 8.5"x11" paper, that cannot print on the topmost 0.5" of paper, has a vertical physical offset of 300 device units.
0
 

Author Comment

by:kburg
ID: 2746974
We use the 11x17 paper to print a Excel spreadsheet and it covers the entire paper.  So, it should work. Also, even though the grid is larger than a 8.5x11 it will print, but runs off the paper.
0
 
LVL 6

Expert Comment

by:DrDelphi
ID: 2747618
The fact that Excel will print it without running off the paper only means that Excel has taken the precaution that I am advising you take, check the actual printable region of the printer's canvas and use that for your print job.Your current printing process, from what you describe , assumes that the printer is going to give you a full 11x17 printable area. This is almost never the case (note my previous post).

Good luck!!
0
 

Author Comment

by:kburg
ID: 2755975
Thanks for your help
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
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…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses
Course of the Month12 days, 15 hours left to enroll

579 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