Blank extra labels printing issue

[neelsfer]

I use the following code on an Argox OS 2014plus label printer, and it works fine but prints one blank label between every printed label. How can i modify the code to move back to the blank label, to prevent wastage..
I select the labels to be printed on a form using a tick box, it's filtered accordingly in a query, before been outputted to a label report and printed.

If Me.meds.Value = "-1" Then
defPrinter = Application.Printer.DeviceName
Set NewPrinter = Application.Printers("Argox OS-214v PPLB")
Set Application.Printer = NewPrinter
DoCmd.OpenReport "lblClientMeds1", acViewNormal
DoCmd.close acReport, "lblClientMeds1", acSaveNo
Set NewPrinter = Application.Printers(defPrinter)
Set Application.Printer = NewPrinter
End If
Me.meds.Value = ""

Please advise
[IMGNOTHUMB]http://bytes.com/attachments/attachment/7795d1407062296/ashampoo_snap_2 014.08.03_12h34 m39s_001.jpg[/IMGNOTHUMB]

[jimatqsi]

Is it possible the report form is designed slightly too long for the actual label form? Maybe label one fills the label and encroaches on label 2 and then the advance to top of next label actual skips the rest of label 2?

Jim

[NeoPa]

That would be my expectation too Neels. Look for where you can reduce the size of controls on the report - if only as a test.

Once you confirm that's the issue you can play with getting it more precisely correct. The report margins are another area you can change to maximise your scope.

[neelsfer]

thx guys, i am now trying the label size settings. Was set on continuous labels, but is actually labels with gaps.When i select 2 labels now, the query seems to filter those 2 behind the report, but display one extra blank one on the label report.(3 records are available, but only 2 were filtered via ticks) .

[jimatqsi]

Actually if you are using a label printer then I'm sure you are using continuous labels. Yes, there may be some gap between your labels on the roll. But to be sure, are you using a roll of 1-up labels?

Check the printer driver you're using, be sure you have all the options on that squared away. Also there may be an identifying brand and number on the labels you use that you can specify in the page set-up in the report design.

Jim

[twinnyfo]

Neels,

Also check your grouping and sorting options. You may have a setting asking for a page break after one of your groupings.

[neelsfer]

Thx for the responses guys. I updated the printer drivers but the real issue was the specs of the label size and type of label in the printer property settings. I also customized the code from http://support.microsoft.com/kb/299024/EN-US , to eliminate blanks and only printout 1 label at a time.

[NeoPa]

Well done Neels. Good to see you got it to work :-)