Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-19-2018, 10:43 AM
Pluviophile Pluviophile is offline Footer On Last Page Only Not Working Windows 7 64bit Footer On Last Page Only Not Working Office 2010 64bit
Novice
Footer On Last Page Only Not Working
 
Join Date: Oct 2013
Posts: 20
Pluviophile is on a distinguished road
Default Footer On Last Page Only Not Working

I have a document that contains a table with a variable number of rows (populated by an external app). In the footer is another table (not variable number of rows) - this is actually the area where the customer signs, and has a bit of legal verbiage.

I want the footer to appear only on the last page, so I wrapped it in

Quote:
{ IF { PAGE } = { NUMPAGES } "

table is here

" }
See attached document example.

The problem is that the footer appears fine if the table in the body doesn't have many rows. It also appears fine if the table in the body has sufficiently many rows that part of it appears on the second page (then the footer table appears on the second page only).

But if the body table has enough rows that the footer table can't fit on page 1 (but not enough rows that some of the body table is pushed to page 2) the footer table doesn't appear at all. The attached example shows the same behaviour.

The question is - how do I make it so that if the body table is too big for the footer table to fit on the first page, the footer table prints on the second page?
Attached Files
File Type: docx Footer Sample.docx (21.0 KB, 23 views)
Reply With Quote
  #2  
Old 04-19-2018, 01:44 PM
Charles Kenyon Charles Kenyon is offline Footer On Last Page Only Not Working Windows 10 Footer On Last Page Only Not Working Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,464
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Try the following:
Quote:
{ IF { PAGE } = { NUMPAGES } "

table is here

""{ IF { PAGE } = { NUMPAGES }+1 "

table is here

" }" }
This may give you the footer on the last page and the preceding page. Otherwise it will be on the last page.
I know this is not what you want.

I'm sure that Paul Edstein will know how to do it better.
Reply With Quote
  #3  
Old 04-19-2018, 01:46 PM
Pluviophile Pluviophile is offline Footer On Last Page Only Not Working Windows 7 64bit Footer On Last Page Only Not Working Office 2010 64bit
Novice
Footer On Last Page Only Not Working
 
Join Date: Oct 2013
Posts: 20
Pluviophile is on a distinguished road
Default

Thanks for the response - but I don't get it. PAGE should never equal NUMPAGES + 1, should it?

And I don't want the footer on the last page and the preceding page - always just on the last page.

And who's Paul Edstein?
Reply With Quote
  #4  
Old 04-19-2018, 03:24 PM
Charles Kenyon Charles Kenyon is offline Footer On Last Page Only Not Working Windows 10 Footer On Last Page Only Not Working Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,464
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by Pluviophile View Post
Thanks for the response - but I don't get it. PAGE should never equal NUMPAGES + 1, should it?
It works. Try it. I know it isn't what you want. It is the best I can come up with. I do not understand the +1 either, but it does display on the last page. It will always display on the last page and in the instances where currently it goes missing, it will display on the last page and the next-to-last page.

Quote:
And I don't want the footer on the last page and the preceding page - always just on the last page.
The problem is that your footer changes the page size so that if it is not showing, the page is the last page. If it is showing, it is not the last page because it changes the pagination and thus doesn't meet the condition. I'm somewhat surprised it doesn't crash Word when it goes into this state.

You could make your table smaller so that it would always fit in the footer area and not change the space available for normal text.

Quote:
And who's Paul Edstein?
Paul Edstein is a regular contributor here and elsewhere and the master of Word fields. He is a Microsoft Word MVP.
Look at some of the pinned threads on fields including this one. I expect he will look at this before long.
Reply With Quote
  #5  
Old 04-19-2018, 03:28 PM
Pluviophile Pluviophile is offline Footer On Last Page Only Not Working Windows 7 64bit Footer On Last Page Only Not Working Office 2010 64bit
Novice
Footer On Last Page Only Not Working
 
Join Date: Oct 2013
Posts: 20
Pluviophile is on a distinguished road
Default

One of the things you mention I messed around with - the footer area. I made it bigger, so that the table would always fit in it, which I thought would be a good fix - but it didn't work. Didn't change a thing. And I can't figure out why it didn't.
Reply With Quote
  #6  
Old 04-19-2018, 05:12 PM
macropod's Avatar
macropod macropod is offline Footer On Last Page Only Not Working Windows 7 64bit Footer On Last Page Only Not Working Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,365
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

I think the best you can do to achieve the desired result with the footer approach is to inspect the document to check the table actually appears on the last page and, if there's insufficient space for it, insert a manual page break at a suitable point. That said, it would look rather odd having an otherwise blank page with a table at the bottom of that page. Accordingly, you might do best to insert the table into the document body and let Word position it immediately after whatever preceding text you have - it's easy enough to ensure the table doesn't break across a page boundary.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 04-19-2018, 06:16 PM
macropod's Avatar
macropod macropod is offline Footer On Last Page Only Not Working Windows 7 64bit Footer On Last Page Only Not Working Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,365
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Cross-posted at: https://stackoverflow.com/questions/...ly-not-working and https://www.office-forums.com/thread...rking.2350293/
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #8  
Old 04-20-2018, 03:00 AM
jec1 jec1 is offline Footer On Last Page Only Not Working Windows 7 32bit Footer On Last Page Only Not Working Office 2013
Advanced Beginner
 
Join Date: Jan 2012
Posts: 84
jec1 is on a distinguished road
Smile Footer - text/graphic not showing

Hi, attached is a .docx.

Please note in the Word document I have placed text and tables that I created in Word 2016.

I have also turned the ftr into an image which I do not think is neither here nor there.

I have also pasted in the Word document a screenshot of Word >Options > etc
and you see that I have checked the boxes suppress line spacing.

This seems to have worked.

The 2016 Word document was going a little crazy on my screen.

Just print it and do not rely on Print Preview to be accurate.

I inserted extra rows in a table and the ftr appeared on last page.
I put only text and a table on page 1 and ftr appeared on page 1.

Let me know how you go with attached document and the Word File Options settings changed.

Janine
Attached Files
File Type: docx TestFtr.docx (110.8 KB, 28 views)
Reply With Quote
  #9  
Old 04-20-2018, 08:58 AM
Pluviophile Pluviophile is offline Footer On Last Page Only Not Working Windows 7 64bit Footer On Last Page Only Not Working Office 2010 64bit
Novice
Footer On Last Page Only Not Working
 
Join Date: Oct 2013
Posts: 20
Pluviophile is on a distinguished road
Default

Thanks a lot - that does work on your document. Now I'll look at moving the settings, etc., over to mine and see how it goes

Thanks again for your efforts.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Don't want page number or date in footer on first page, do want graphic in header. dianahbr Word 2 02-23-2018 09:25 AM
I have 20 page word document with a footer. Can i change page # 10 footer only? aligahk06 Word 2 10-25-2017 04:53 AM
Footer On Last Page Only Not Working Total Page number incorrect in the first page footer mmathisekar Word 11 06-16-2016 06:00 AM
Footer On Last Page Only Not Working begin each section with page 1 in header PLUS continuous page numbering in footer onemorecupofcoffee Word 18 09-04-2013 04:31 PM
How to save the current page in a new file with all the page settings (header, footer Jamal NUMAN Word 6 03-15-2012 03:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:32 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft