Printing a label

[J]

I have a new Brother QL-500 Label Printer and I am trying to print labels
from Microsoft Access 2000-2003. In design mode, I right-click on the
report that I created and select print from the menu, the page count in the
print queue exceeds 1 page by alot. It queues hundreds of pages possibly
even thousands if I let it go that long before aborting the print job.



If I do the same thing, but have my default printer set to my other printer
(not a label printer, but an hp desktop printer), only one page gets
printed.



Any help on why this might occur would be appreciated.

 

[Wayne Morgan]

A label printer usually prints just one label at a time. In design mode,
you're not printing the label, you're printing the design view of the
report. I'm sure it would occupy the space of more than one label. If so,
Windows will break it down into label sized chunks and print as many of
these chunks as needed to print the design view of the report.

 

[J]

Hi Wayne! Thanks for the reply, I'm actually in print preview mode. When I
click on print, the page count keeps going up very fast, like I mentioned.
Could it be a driver issue? I'm really stumped on this one.

Thanks, J

 

[J]

Hi Wayne! Thanks for the reply, I'm actually in print preview mode. When I
click on print, the page count keeps going up very fast, like I mentioned.
Could it be a driver issue? I'm really stumped on this one.

Thanks, J

 

[Wayne Morgan]

You said that you get one page if you print to a standard sheet of paper.
How many labels are printed on the sheet? Is the report size in design view
larger than a single label?

Assuming the label printer only prints one label at a time, you'll probably
need to format the report in design view to have the report size the same as
the label size less the margins. For example, if you have to set the margins
for 0.1" on each side for the printer to work correctly and the label is
2"x3" then the report's background area should be 1.8"x2.8". In File|Page
Setup you'll need to set it for 1 column with enough row spacing to handle
the gap between labels, if any. On the Page tab, you'll need to select a
Specific Printer unless the label printer is the default and select the
correct Size and Source for the labels. Set Portrait or Landscape as
necessary. Just guessing, but I suspect it will be landscape.

As you can see, with all of these changes, it won't print properly on both
the label printer and standard paper.

As far as whether or not there is a driver problem, that's always a
possibility. You may want to check the manufacturer's web site to see if
they have a newer driver.

 

[Wayne Morgan]

You said that you get one page if you print to a standard sheet of paper.
How many labels are printed on the sheet? Is the report size in design view
larger than a single label?

Assuming the label printer only prints one label at a time, you'll probably
need to format the report in design view to have the report size the same as
the label size less the margins. For example, if you have to set the margins
for 0.1" on each side for the printer to work correctly and the label is
2"x3" then the report's background area should be 1.8"x2.8". In File|Page
Setup you'll need to set it for 1 column with enough row spacing to handle
the gap between labels, if any. On the Page tab, you'll need to select a
Specific Printer unless the label printer is the default and select the
correct Size and Source for the labels. Set Portrait or Landscape as
necessary. Just guessing, but I suspect it will be landscape.

As you can see, with all of these changes, it won't print properly on both
the label printer and standard paper.

As far as whether or not there is a driver problem, that's always a
possibility. You may want to check the manufacturer's web site to see if
they have a newer driver.