Avatar of Kevin Willyerd
Kevin Willyerd
Flag 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?

DB Reporting ToolsMicrosoft Access

Avatar of undefined
Last Comment
Kevin Willyerd

8/22/2022 - Mon

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?
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.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
Hamed Nasr

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
Jeffrey Coachman

<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, ...post 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.

Kevin Willyerd

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Jeffrey Coachman

Then you should not have accepted any posts here if you found the solution elsewhere...
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Hamed Nasr

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.
Kevin Willyerd

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