Controlling paper size when printing on label by function call

[Thorben Grosser]

(due to problems with my newsreader, repost here)
Hello newsgroup,

I'm finally done with my folder-archiving tool, still there are some
flaws.

To label the folders, I use a Dymo LabelWriter 400 printer which works
great for my purposes.

I've created a report to print the labels. When I print (page 1 to 1
as I don't want to print all the records stored in the database) the
report out of the report preview, it prints my label just the way I
wanted to have it.
When I use a function to print the report (DoCmd.OpenReport
report,acViewNormal,,WHERE id = id,,) it suddenly prints the label I
wanted PLUS 3 empty labels, which is - as the Dymo has no reasonable
scrollback function - complete waste of labels.
I have a slight guess about the problem. As four labels would match
for an A4 page, it might be that he's just pulling as many labels as
he needs to fit an A4 page. But this is just a guess. When adding a
thin line it the footer, he prints parts of that thin line over the
last 3 labels.

So, anyone any idea how this weird situation could be solved?

thanks
Thorben Grosser

 

[Paul Shapiro]

I emailed you a vba class module that uses the Dymo Label Software to enable
printing that matches the features of their software. I prefer this to an
Access report since their software automatically reduces the font size if
necessary to fit the label on the paper.
Paul Shapiro