Link to home
Start Free TrialLog in
Avatar of Kevin Willyerd
Kevin WillyerdFlag for United States of America

asked on

2 rows of labels. How??

I have some labels i need to print. The labels print correctly but only the first tow of 5.  The second row gets skipped.

|               |               |               |               |               |
| label1    |  Label2  |   Label3  |  Label 4  |   label5  |
|               |               |               |                |              |
|               |               |               |               |               |
| Blank     | Blank     |  Blank     | Blank      |  Blank   |
|               |               |               |                |              |

and it continues to page two for label6.
How do I format it to print label 6 to label 10 under 1 to 5?

Avatar of CanterburyComputers

Print to a text file and then check you have a line feed at the end of each line and not a page feed
What is the size of the label sheet? Of the individual labels? Are the margins set correctly?
Avatar of Scott McDaniel (EE MVE )
There are many formatting options for reports, so it's difficult to say exactly where the issue is. As ramrom suggests, Margins are highly suspect when you seem to have issues like this, but you can also have settings that can force new pages. Genereally a margin issue results in a blank page, of course, so you'd have one page with your first row of labels, a second blank page, and then a 3rd page with your next row of labels, and so on.

Check these formatting properties


Also, any Grouping headers you may have can have those same formatting properties, so refer to those as well.
What is stopping you from doing that! L=Label, F=Field

In Page header:
L1   L2   L3   L4   L5
L6   L7   L8   L9   L10

In detail:
F1   F2   F3   F4   F5
F6   F7   F8   F9   F10
<There are many formatting options for reports, so it's difficult to say exactly where the issue is.>

If you posted a sample of this database that demonstrates this issue, I am sure that any Expert can get you going.

Sample database notes:
1. Back up your database(s).
2. Combine the front and back ends into one database file.
3. Remove any startup options, unless they are relevant to the issue.
4. Remove any records unless they are relevant to the issue.
5. Delete any objects that do not relate directly to the issue.
6. Remove any references to any "linked" files (files outside of the database, Images, OLE Files, ...etc)
7. Remove any references to any third party Active-x Controls (unless they are relevant to the issue)
8. Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
9. Unhide and hidden database objects
10. Compile the code. (From the VBA code window, click: Debug-->Compile)
11. Run the compact/Repair utility.
12. Remove any Passwords and/or security.
13. If a form is involved in the issue, set the Modal and Popup properties to: No
    (Again, unless these properties are associated with the issue)
14. Post the explicit steps to replicate the issue.
15. Test the database before posting.

In other words, a database that we can easily open and immediately see and/or troubleshoot the issue.
And if applicable, also include a clear graphical representation of the *Exact* results you are expecting, based on the sample data.

Avatar of Kevin Willyerd
Kevin Willyerd
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Then you should not have accepted any posts here if you found the solution elsewhere...
Does my comment help in directing you to the solution?
Your comment may enforce my understanding of your problem? You may need an automated way of laying out labels and fields on the report.
Avatar of Kevin Willyerd


I ended up finding Markus Fischer's article on labels and it solved the problem.