Reports and Access 2000 MDE
Posted on 2004-10-15
I have an Access 2000 Application with about 300 reports It runs on win 98, win 2000 and XP. The problem I am having is that my users can have any printer there are over 5000 of them. In Access 97 I did not have a problem. Having moved to Access 2000 I am having problems with Win 2000 and XP. The problem comes in when some one prints a report based on a custom paper size it always prints on letter size paper. for example a single colum dot matrix mailing label prints on a ltter size sheet. I have tried setting the reports to the default printer and I have defined a printer called "MyPrinter" and it will work on the development system. When I go to another system and define the same printer with the same name it comes up letter. I need to know how to make it use the custome paper sizes. I have routines that use the CreateForm and SetForm API to create the form on the printer. The printer drivers are installed locally. Any advice or ideas would be greatly appreciated.