Print using a Dymo labelwriter from Access

[Tucsonshark]

I'm trying to print labels using a new Dymo labelwriter. Dymo has
instructions that are supposed to work, but Access still prints 1 label and 3
blank ones. Has anyone done this successfully??

 

[Graham Mandeno]

You must ensure that the size of your detail section (I assume there are no
headers or footers), PLUS the margins, fits into the size of the label.

Sometimes Access can be a bit difficult about setting margins outside what
it thinks is the printable area, so you might need to put some code to set
the margins in the report's Open event:

Private Sub Report_Open(Cancel As Integer)
With Me.Printer
.LeftMargin = 200
.TopMargin = 90
.RightMargin = 0
.BottomMargin = 0
End With
End Sub

 

[paul]

Could simply be that the margins are too big on the report you are trying to
print out.

Try making your report really small and printing a test to see if you still
have the same problem.
Also change the margins in page setup so they are 0 (They may automatically
go a bit bigger).

Paul