We help IT Professionals succeed at work.

2 rows of labels. How??

487 Views
Last Modified: 2012-06-03
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?


Kevin
Comment
Watch Question

Print to a text file and then check you have a line feed at the end of each line and not a page feed
ramromconsultant

Commented:
What is the size of the label sheet? Of the individual labels? Are the margins set correctly?
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
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

KeepTogether
ForceNewPage
NewRowOrCol

Also, any Grouping headers you may have can have those same formatting properties, so refer to those as well.
Hamed NasrRetired IT Professional
CERTIFIED EXPERT

Commented:
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 CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
<There are many formatting options for reports, so it's difficult to say exactly where the issue is.>
Correct

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.

JeffCoachman
CEO
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
Then you should not have accepted any posts here if you found the solution elsewhere...
Hamed NasrRetired IT Professional
CERTIFIED EXPERT

Commented:
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.
PetGuyCEO

Author

Commented:
I ended up finding Markus Fischer's article on labels and it solved the problem.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.