467,915 Members | 1,146 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

Controlling paper size when printing on label by function call

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

Oct 29 '07 #1
  • viewed: 1892
Share:
1 Reply
Thorben Grosser wrote:
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
Do you have the most up-to-date print drivers for it?

Next, when you create the report, in File/PageSetup, is the page size
correct?

Next, do you have the column and height size correct?

Have you checked the properties for the printer and modified as needed?
Oct 29 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Carlos Kirkconnell | last post: by
reply views Thread by Carlos Kirkconnell | last post: by
reply views Thread by mykidisgollum | last post: by
5 posts views Thread by Brian DSouza | last post: by
3 posts views Thread by D Witherspoon | last post: by
4 posts views Thread by Sukh | last post: by
1 post views Thread by Agnoletto Christian | last post: by
1 post views Thread by Anne DeBlois | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.