Pre-printed stationery orientation in printer setup

[drazeni]

Hi, I am using Access XP Developer although the database is in 2000 format. I have a Win 2000 machine which I develop on but the final program will operate on Win 98 machines.

I am trying to setup an invoice report on A4 pre-printed stationery. The paper is 4-part cut sheet and fed into the printer in a landscape position.

When I configure the printer's orientation as landscape, it prints the invoice sideways on the page. If I set it to portrait, the whole invoice doesn't fit on the page and the right-hand portion gets cut and carried to the next page.

Is there a printer specific setting (maybe a printer code or dip switch) that should be configured, or is it in the Windows printer setup itself (tested on an Epson LX-1050+ wide printer).

The printer setup in Windows 2000 doesn't give me the option of selecting an A4-landscape on this printer. I have also tried custom page size with no luck when printing (for some reason the setting wouldn't apply all the time).

Any suggestions will be appreciated? "All is not as it seems"

 

[bethabernathy]

Hi - Are you able to set up the page at all or are you just having trouble maintaining the page settings.

Beth

 

[drazeni]

It's the page setup I'm having trouble with. I have tried installing a generic printer using the Epson printer and have inserted the following decimal printer control code for the page size (length in lines) "27 67 21" (21 is the page length) but it appears that win 98 isn't using the code when printing in Access because it still prints over 2 pages.

My main problem is setting up the page length because the page is not a standard size. If I select a custom page size the value 25 (0.1 mm) is the smallest value and I have a page legth of 21.5. Basically what I need is the proper setup of the generic printer driver in Win 98 to specify the correct page length. Win 2000 does this without a problem and it prints correctly in Access.

Thanks "All is not as it seems"

 

[drazeni]

I found out part of my problem. In the custom page size definition, I wasn't converting my page width and length to 0.1 of a millimetre (multiply the real value by 10) before inserting the values.

I have started a new post because the custom page size is working now, just got a problem with my runtime version of the DB not keeping the user-defined setting within Access and reverts back to A4 everytime I restart the runtime DB.

If you have an reply you may reply here or see my post "Runtime version not keeping printer settings"

Thanks for the reply anyway Bethabernathy. "All is not as it seems"

 

[bethabernathy]

Hi There: There is a bug in Access 2000 which causes the printer settings to revert to the default when the "Perform Name Autocorrect" feature is enabled. To make things more insane, the problem only occurs the second time the report is previewed.

This article explains the problem.

Go to the following URL:

http://support.microsoft.com/support/kb/articles/Q240/8/26.ASP?LN=EN-US&SD=gn&FR=0

The quick fix is to uncheck "Perform Name Autocorrect" (Tools, Options, General Tab). The permanent fix is to download Office 2000 Service Release 1/1A (just a small 20mB download).

Beth

 

[drazeni]

Unfortunately, the disabling of the "perform name autocorrect" didn't work in the runtime version, but I did find an intersting article of how to program the printer settings in Ms-Access 2002 at the following link:

http://msdn.microsoft.com/library/d...ry/en-us/dnacc2k2/html/odc_acc10_printers.asp

which I will attempt as my next step. "All is not as it seems"