Problem when printing report

[bosve73]

I have a report that I use for printing labels. The problem is the first row of labels are perfect but the second row and further the labels are moved by 1cm downwards, the second row is then moved 2cm...
Any tips why the report does that?

[RuralGuy]

Have you played with the font or line spacing as a test on just paper to see what might be going on? How about the label you picked?

[bosve73]

Have you played with the font or line spacing as a test on just paper to see what might be going on? How about the label you picked?

Have been playing around now for couple hours and still I have the same problem only now it just a couple of milimeters the labels move down for each row. So annoying

[bosve73]

I thnik it is the marginal at the bottom that is the issue. If I set it to 0 it automatically changes that to 4,23mm as that it the bottom limit for the printer. The problem is the report somehow spiltes that per row so each row gets extra 4mm at the bottom which causes the text to move upwards.

[RuralGuy]

Have you tried defining your own label dimensions?

[bosve73]

Have you tried defining your own label dimensions?

Yes, the labels where created from scratch.

[RuralGuy]

As a test, I would shrink down the font and run a test page on paper and see if the same thing happens.

[bosve73]

As a test, I would shrink down the font and run a test page on paper and see if the same thing happens.

Same thing happens

[RuralGuy]

Did you use really small font - like point 8? I'm flat out of suggestions for now, sorry.

[bosve73]

Did you use really small font - like point 8? I'm flat out of suggestions for now, sorry.

No, right now I use point 12 font. Only diffrence is that it is less noticable when font is smaller. This is very strange...i even had a help from senior developer and he couldn't find what was wrong.

[RuralGuy]

Your label form should only show one label. Does it? Did you use the access label form wizard?

[bosve73]

Your label form should only show one label. Does it? Did you use the access label form wizard?

No I didnt' use the label form wizard.
Only show one label? Yes i only use one label design for all my labels.

[RuralGuy]

I'm afraid I'm fresh out of new suggestions, sorry.

[pkstormy]

I know exactly where you're coming from.

Do you have any fields which allow growing/shrinking? (although I doubt that would be the issue). I've spent hours and hours with labels on a report getting them to size correctly, usually having the same problem as you are having where the first row prints nicely but it slowly grows in spacing with each row. I found that sometimes if I played with Grid X and Y, I could get the millimeter that it's off for each label row to space correctly. Sometimes it would also be related to the left/right margins or spacing between the labels or as you've done, I played around with the top/bottom margin (which was usually the problem). I often set the top/bottom to the minimal margin (I think it's .25) and then adjusted the labels from there.

Another thing I would do to help with adjusting the spacing correctly is to create a border type box around the label. That made it a little easier to determine where the spacing was off. I print them on blank pieces of paper and then hold them up in the light against the labels themselves. (We print DNA labels which have to match exactly to the label size.)

But getting labels to size correctly for the spacing between each row is the most frustrating thing I've spent my time on versus coding for the last 15+ years. I will sometimes even turn this job over to someone else and have them do it in word via a mailmerge (or even trying a different printer.)

If at all possible and the specific label type is listed in the wizard, try using that as Allan suggested. I've had more success doing it that way versus manually (but usually the labels I'm using isn't listed in the wizard unless I use MSAccess 2007 versus 2003.)