Access 2003 Looses Zebra LP 2844 Printer Portrait/Landscape control, suddenly.

[Ashton]

[RESOLVED] Access 2003 Looses Zebra LP2844 Printer Portrait/Landscape control

Strangely, sometime after installing a new driver for an LP 2844 printer (that had been reliable for years), and creating a set of new USPS like label reports, I apparently lost Portrait/Landscape control. Killing a huge set of inventory & product labels that have been used with the LP 2844 for years. (I'm In Big Trouble over this I must say)

So in my case, the newer 4" X 6" labels are printed in Portrait, they are ok. But a large group of my 2" X 1" and 3" X 1" labels that print in Landscape are affected. Regardless if Portrait or Landscape is selected, all labels/output of the LP 2844 are printed in Portrait. Using MS Word to print test labels, I find that the LP 2844 does follow commands of Portrait/Landscape control, just not in Access.

I should maybe clarify, when creating/editing a label in Access, the Print Preview and Layout Preview will not display the lines of text over the length of a 2 or 3 inch wide(by 1 inch High) label for example, unless the Page Setup's Orientation is set to Portrait. When the page orientation is set to Landscape (as previous and in MS Word), the lines of text are displayed across the label depicted vertical (2"H X 1" W), with text cut off on the right side, and carried to one or more additional labels. I have worked with MS Access since version 2 and have never observed such an anomaly. I will be testing this on newer Access versions soon.

Any suggestions greatly appreciated.

 

[JHB]

Do you have some code running behind (+ error handling), which try to setup the printer?

I would make a brand new report (no copy) with some label controls in, and set it up to landscape and see if it would print out correct.

[FONT=&quot]Can't you get the old driver installed again?[/FONT]

 

[Ashton]

No, the only code is to launch the report:

Private Sub cmd213Rpt_Click()
'On Error GoTo Err_Print_Label_Click
    Dim stDocName As String
    stDocName = "rpt2X1_3Ln"             ' "rpt1X2_3Ln"
    DoCmd.OpenReport stDocName, acPreview 'or acNormal
Exit_Print_Label_Click:
    Exit Sub
Err_Print_Label_Click:
    MsgBox Err.Description
    Resume Exit_Print_Label_Click
End Sub

I did create a new report late last night with text boxes, same results. I have stepped back to an older driver, but same results. I'm really not sure which older driver had been working. I'll re-test old drivers today. Seems like my old driver didn't try to follow the 'ZDesigner' naming convention.

Using Labels instead of text boxes gave the same results.

 

[Ashton]

I'm not thrilled with this fix, but my labels are printing correctly. I solved by creating a 2" W X 2" H Column size, and Landscape orientation under Page Setup. The text boxes now being placed near or below center of the pane. The printer's format set to Portrait. This will be disorienting to users, I'm sure I'll hear about this.