Printing Labels on label printer

[dtorti]

I've created labels in my database and when I print them on a label printer, I get a blank label in between my printed labels. I've checked the printer settings and properties and can't find anything. I've also checked the database properties and can't find anything. Is there something in the database that I'm missing?

 

[David R]

Like
[LABEL][BLANK][LABEL]
[BLANK][LABEL][BLANK]

or
[LABEL][LABEL][LABEL]
[BLANK][BLANK][BLANK]
?

If the latter I suspect you have some sort of width problems with your labels, and it's causing blank lines to expand the label. If the former, have you checked for actual blank records in your underlying table/query? Try running your recordsource (query) by itself without the label formatting.

Also did you build your labels from the Wizard? I find it pretty robust, so it might just be worth starting your label report over from scratch, if the recordsource is solid.

 

[dtorti]

Hi David,

It's
[LABEL]
[BLANK]
[LABEL]
[BLANK]

I'm using a Brother Label Printer and the labels are in a roll not a sheet.

My recordsource (query) is simple and is pulling the information fine. In fact, when it prints on the label, eventhough I've set the label size, the information that I'm printing is smaller than the label.

I built the labels using the wizard. I'll try creating it from scratch.

Diana

 

[dtorti]

Thank you Richard. I'll give it a try.

Diana

 

[dtorti]

Richard,

Just wanted to let you know it worked.

Thank you again for your help.

Diana

 

[daljitphull]

Thank you for that. I will give it a try and see how far i get with it. Does the user need to select the printer every time they want to print?

I need to give them something, where i can hard code the printer in.

The idea is to have a button on a form, that has all the data, to be printed on the label, with as little input from the user....so almost like a print button but to a dymo.

First make sure you're printer installed correctly, during setup do not plug in USB devices into computers until the software asks you to.

Create a new report in design view, and choose a record source. (Do not add your Existing Fields) yet.

Next from the ribbon select Page Setup, in the properties select the page tab.

Select “Use Specific Printer”, find your printer in the drop down. The “Size” properties will change to reflect your printer.

Select the paper (labels) that closely fits your needs. Click on the print options tab of the page setup properties and delete each of the settings in the margins boxes and let them reset.

Look at the square notch of the upper left corner of your report, is there a green triangle? If so you need to move the work space a little to the left or up until the triangle disappears. If there is no green triangle you may be able to expand your work area slightly.

Now add your Existing Fields, usually set them small (9-10) font and don’t use fancy fonts here stick with the basics. Also you "can" delete the labels to the left of each textbox as they are created most of the time you do not have the space for them.

Labels are expensive so if you want to practice on plain paper set your page setup to default printer instead of “Use Specific Printer” or use print preview on your reports code to view on your screen. I hope this helps.

Richard

 

[mafhobb]

Soooo....By following the process you describe above for each label (I have two different labels to be printed in two different printers) then the specific printer stays with the specific label?

That's it?

mafhobb