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  dBforums > PC based Database Applications > Microsoft Access > Label Report...last row missing!

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-14-03, 15:19
Pogen Pogen is offline
Registered User
 
Join Date: Jan 2003
Posts: 2
Label Report...last row missing!

Hi,
I produced a Label Report (using the Wizard) to fit on A4 paper using Avery L7161 Labels (3 x 6). The problem is that the last row of labels on each sheet remains blank - it's only previewing & printing 5 instead of 6 rows per page. With the Report in any view I notice that Page Setup looks as such:
Margins: Top: 8.78mm Bottom: 14.04mm Left: 7.62mm Right: 7.62mm

That 14.04 Bottom margin seems to be causing the problem. Unfortunately, when you manually change it (in any view), it pops back to 14.04 upon closing Page Setup!!!

Figuring it out, both Top & Bottom margins should be 8.7mm.
That way, with each label being 46.6 high you get (8.7*2)+(46.6*6) = 297 (A4 height)
So why isn’t the wizard working or am I being really stupid here?
Reply With Quote
  #2 (permalink)  
Old 01-14-03, 15:41
FirstAndGoal4 FirstAndGoal4 is offline
Registered User
 
Join Date: Nov 2002
Posts: 150
Re: Label Report...last row missing!

Does the last row print on the next sheet?
Reply With Quote
  #3 (permalink)  
Old 01-14-03, 16:09
Pogen Pogen is offline
Registered User
 
Join Date: Jan 2003
Posts: 2
Label Report...last row missing!

Yes, it goes to the next page.
I now discover, having tried several other size labels, that I get the same problem in all of them! Where is this spurious Page Setup coming from and why I can't I change it.
Reply With Quote
  #4 (permalink)  
Old 09-04-03, 14:36
Greg Durward Greg Durward is offline
Registered User
 
Join Date: Mar 2002
Posts: 7
I had this problem trying to print with two ink jet printers and then tried on a laser. It worked. I think it was because the bottom margin required by the laser was less. The minimum margin that Page Setup would accept for the ink jets was .55" but it took less than .5" for the laser.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On