Results 1 to 5 of 5
  1. #1
    uoghk is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jan 2022
    Posts
    149

    Label print blank pages

    I have a label "CouponLabel" with setting as below


    Click image for larger version. 

Name:	label1.png 
Views:	14 
Size:	23.6 KB 
ID:	49943


    When I run the code : DoCmd.OpenReport "CouponLabel", acViewPreview, , "ID=" & IdNo
    It shows 6 labels, the first & second labels are blank and the fourth to sixth also blank.
    only the third label are correct, as shown below.
    Click image for larger version. 

Name:	label2.png 
Views:	14 
Size:	17.6 KB 
ID:	49944
    If I change the IdNo to print another record, it still the same.
    CouponLabel is set to use specific printer QL800 and printer's setting is shown below
    Click image for larger version. 

Name:	label3.png 
Views:	14 
Size:	30.4 KB 
ID:	49945

    How to solve it? thanks.
    Or can I just print the third page?

  2. #2
    madpiet is online now Competent Performer
    Windows 10 Office 365
    Join Date
    Feb 2023
    Posts
    132
    I would reduce the margin size and see if that fixes it. It looks like the report "sees" the labels as too large, so it's forcing page breaks where you don't want them. So make the margins smaller. Did you use the wizard to create the report? (Maybe try that)

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,895
    This printer is a single label printer. Why is report producing 6 labels when you need only one?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    uoghk is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jan 2022
    Posts
    149
    I try using the wizard to create label names "Labels". But it shows error as shown below
    Click image for larger version. 

Name:	label4.png 
Views:	12 
Size:	26.4 KB 
ID:	49947
    Its page setting is below
    Click image for larger version. 

Name:	label5.png 
Views:	12 
Size:	42.3 KB 
ID:	49948
    The report width is 5.806cm and page width is 6.2cm. don't know why it gets error?

  5. #5
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,002
    Set all the margins to 0.

    According to the brother image you posted up you have the width and height round the wrong way, or the image is very confusing.
    Untick the "Same as Detail" option as well
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 10-08-2017, 12:53 PM
  2. not print blank pages when a subreport is empty
    By fabiobarreto10 in forum Reports
    Replies: 3
    Last Post: 04-28-2012, 10:01 AM
  3. Replies: 10
    Last Post: 03-06-2012, 11:48 AM
  4. Blank Pages in my Reports
    By bkvisler in forum Reports
    Replies: 2
    Last Post: 08-21-2011, 03:15 PM
  5. Blank pages between report pages
    By jonsuns7 in forum Reports
    Replies: 2
    Last Post: 10-01-2009, 05:06 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums