A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Bottom row of labels empty



 
 
Thread Tools Display Modes
  #1  
Old November 5th, 2004, 05:28 AM
Gerald Lindinger
external usenet poster
 
Posts: n/a
Default Bottom row of labels empty

I have the same problem already posted earlier, but the answer

This is normally due to printers that can't print within 1/2" from the
bottom of the page. You may need to:
Decrease your top margin by a small amount
Add the same small amount to your bottom margin
Move controls on the report down the same small amount
--
Duane Hookom
MS Access MVP


do not help me (I tried on several HP-Ink Jets).

Even if I go to the minimum at top and bottom margin (I entered on both top
and bottom a "0" and got so finally the minimal value, when I reopend the
page settings), the last row is blank ?

Then I increased the bottom value several times by small values, but this
did not change anything ?
It seems to me, that the sum of the vertical size of all labels always is
greater than the printable size. Only if I reduce the vertical size of the
labels in the report, than it works, but than the position of the text on the
labels of the Zweckform 3474 changes from top to bottom.

Thanks
Gerald Lindinger

  #2  
Old November 5th, 2004, 05:34 AM
Duane Hookom
external usenet poster
 
Posts: n/a
Default

Do you mind providing:
Height of your labels:
Number of labels down:
Space above the top label on your paper:
Space below the bottom label on your paper:
Minimum top margin allowed by your printer:
Minimum bottom margin allowed by your printer:

--
Duane Hookom
MS Access MVP
--

"Gerald Lindinger" wrote in
message ...
I have the same problem already posted earlier, but the answer

This is normally due to printers that can't print within 1/2" from the
bottom of the page. You may need to:
Decrease your top margin by a small amount
Add the same small amount to your bottom margin
Move controls on the report down the same small amount
--
Duane Hookom
MS Access MVP


do not help me (I tried on several HP-Ink Jets).

Even if I go to the minimum at top and bottom margin (I entered on both
top
and bottom a "0" and got so finally the minimal value, when I reopend the
page settings), the last row is blank ?

Then I increased the bottom value several times by small values, but this
did not change anything ?
It seems to me, that the sum of the vertical size of all labels always is
greater than the printable size. Only if I reduce the vertical size of the
labels in the report, than it works, but than the position of the text on
the
labels of the Zweckform 3474 changes from top to bottom.

Thanks
Gerald Lindinger



  #3  
Old November 5th, 2004, 06:14 AM
Gerald Lindinger
external usenet poster
 
Posts: n/a
Default

Labels are Zweckform 3474
Height = 3,7 cm (3,709 created in the report by the label assistant)

Number of labels = 8

Space above the top label on your paper: approx. 0.4mm
Space below the bottom label on your paper: approx. 0.4mm

Minimum top margin allowed by your printer: 1,69 mm
Minimum bottom margin allowed by your printer: 12,45 mm

Gerald Lindinger

"Duane Hookom" wrote:

Do you mind providing:
Height of your labels:
Number of labels down:
Space above the top label on your paper:
Space below the bottom label on your paper:
Minimum top margin allowed by your printer:
Minimum bottom margin allowed by your printer:

--
Duane Hookom
MS Access MVP
--

"Gerald Lindinger" wrote in
message ...
I have the same problem already posted earlier, but the answer

This is normally due to printers that can't print within 1/2" from the
bottom of the page. You may need to:
Decrease your top margin by a small amount
Add the same small amount to your bottom margin
Move controls on the report down the same small amount
--
Duane Hookom
MS Access MVP


do not help me (I tried on several HP-Ink Jets).

Even if I go to the minimum at top and bottom margin (I entered on both
top
and bottom a "0" and got so finally the minimal value, when I reopend the
page settings), the last row is blank ?

Then I increased the bottom value several times by small values, but this
did not change anything ?
It seems to me, that the sum of the vertical size of all labels always is
greater than the printable size. Only if I reduce the vertical size of the
labels in the report, than it works, but than the position of the text on
the
labels of the Zweckform 3474 changes from top to bottom.

Thanks
Gerald Lindinger




  #4  
Old November 5th, 2004, 04:14 PM
Duane Hookom
external usenet poster
 
Posts: n/a
Default

According to my calculations assuming A4 paper (297 mm height), you won't
get this to work. Your printer is not capable of printing close enough to
either the top or bottom of the page.
1,69 + 12.45 + (8*37) 310
Normally inkjet label paper "burns" half label (18.5 mm) at the top and half
label at the bottom.
--
Duane Hookom
MS Access MVP
--

"Gerald Lindinger" wrote in
message ...
Labels are Zweckform 3474
Height = 3,7 cm (3,709 created in the report by the label assistant)

Number of labels = 8

Space above the top label on your paper: approx. 0.4mm
Space below the bottom label on your paper: approx. 0.4mm

Minimum top margin allowed by your printer: 1,69 mm
Minimum bottom margin allowed by your printer: 12,45 mm

Gerald Lindinger

"Duane Hookom" wrote:

Do you mind providing:
Height of your labels:
Number of labels down:
Space above the top label on your paper:
Space below the bottom label on your paper:
Minimum top margin allowed by your printer:
Minimum bottom margin allowed by your printer:

--
Duane Hookom
MS Access MVP
--

"Gerald Lindinger" wrote in
message ...
I have the same problem already posted earlier, but the answer

This is normally due to printers that can't print within 1/2" from the
bottom of the page. You may need to:
Decrease your top margin by a small amount
Add the same small amount to your bottom margin
Move controls on the report down the same small amount
--
Duane Hookom
MS Access MVP

do not help me (I tried on several HP-Ink Jets).

Even if I go to the minimum at top and bottom margin (I entered on both
top
and bottom a "0" and got so finally the minimal value, when I reopend
the
page settings), the last row is blank ?

Then I increased the bottom value several times by small values, but
this
did not change anything ?
It seems to me, that the sum of the vertical size of all labels always
is
greater than the printable size. Only if I reduce the vertical size of
the
labels in the report, than it works, but than the position of the text
on
the
labels of the Zweckform 3474 changes from top to bottom.

Thanks
Gerald Lindinger






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
bottom row of labels blank Walter Oliver Setting Up & Running Reports 1 September 19th, 2004 05:02 AM
Mail Merge Mailing Labels crodal Mailmerge 0 September 16th, 2004 03:33 AM
Label SRIT General Discussion 2 June 22nd, 2004 09:42 PM
Problems Printing Mailing Labels... Grim Reaper Setting Up & Running Reports 0 May 19th, 2004 12:31 AM
bottom row labels or footers kathy Setting up and Configuration 2 December 6th, 2003 04:06 PM


All times are GMT +1. The time now is 09:46 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.