-
Default Legal paper
I have a report that is printed to different printers by the user. The report has to be printed on Legal paper. When I change the paper select in the report it works fine when the report is printed to the printer that was selected as the default printer at the time the report was saved. If I print the report to a printer that was not my default printer the reports prints on letter size paper. I want the paper to be legal no matter what printer the report goes to and no matter what the default printer is. This has been driving me nuts for a long time.
-
-
I don't ever remember having this problem with preious version of Access. Does anyone else know of this problem in Access? If the report is set to print on legal then regardless of the printer selected it should print on legal.
-
What about the API code from that article?
-
I figured that I was just missing something somewhere. If this is a problem for everyone then the article does look like it has the solution. I figured that I was just missing something simple especially since i don't remember having this problem before.
-
I have never tried printing on legal paper with Access reports, so I wouldn't know. BTW, here's the Access equivalent of that Word article: http://msdn.microsoft.com/library/de...0_Printers.asp
-
I am going to try it, thanks.
-
BTW, what country are you in that it's 4:50 AM?
-
-
Ah, incorrect TZ. Always the Americans who are too stupid to set the correct TZ. You're making me look bad!!!!! J/K 
Default must be GMT.
-
bkudulis, were those articles helpful?
-
I was still hoping that someone would confirm that the problem exists. I am not sure if this will work or not since it refers to Access 2003 and I am using 2000. We can close it though.
-
I'm pretty sure the problem exists. If any program were to work with legal paper, it would be Word, but it doesn't. There's too much code out there from Microsoft to make me think there's something that we're missing. MHO.
-
Where do you stand with this? Did you come up with a different solution?
-
My workaround for such problems is to add another version of the printer(s) which is set to the relevant papersize settings and naming it accordingly eg HP_Legal
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
No I have not found a solution for this yet. The Access solution is for Access 2002 and the Word solution is for Bins which are different on all of the printers that are being used. I'll just have to keep looking.
-
Malcom's suggestion is a good one unless you're in a big enterprise environment where your access application will be deployed and printing on a multitude of printers (which might mean butting heads with IT folks about extra drivers). Anyway, that code for Access I linked to should do the job. The version is irrelevant. Also, the code for Word could be adopted pretty easily.
-
I have tried copying over the sample DB that was in the link (Access) and it keeps giving me errors about things not being defined. According to the article it is for Access 2002. In Access 2002 there are new Printers Collections and Printer objects whic are not in 2000. I can run it in a 2000 db that has the 2002 version installed on the machine but as soon as I put it on a 2002 version I cannot open the form because of the errors. I am totally frustrated with this thing, it shouldn't be this difficult.
-
I'm sorry. I made the stupid assumption (don't know why) that you were using 2003. I need to recheck the Word code now.
-
Well, I think the Word code could be adopted, since it doesn't use the printers collection. But, what about Malcom's suggestion? Why not make another driver and set the tray there to what you want?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Reply With Quote
