Microsoft Access Forums

Go Back   Microsoft Access Forums > Access Forums > Reports

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-14-2005, 09:56 AM
Novice
 
Join Date: Oct 2005
Posts: 13
RHall
Default Page Footer Top

I have a form letter that has details. The page footer has a text box that has standard info . After the last detail has printed there is a gap between it and the start of the standard info in the page footer.

I would lke to move the standard info uip closer to the last detail printed.

How is this done. I have seen info in this forum that uses the me.top. From what I can determine this is set based on a distance from the top of the form.

Is there a method that will allow the footer top to be set by the bottom of the detail section. The detail section can grow so the distance from the top changes.

Any asistance is appreciated.
Reply With Quote
  #2  
Old 12-14-2005, 12:00 PM
Expert
 
Join Date: Dec 2005
Location: Wilmington, DE - USA
Posts: 275
matthewspatrick
Send a message via MSN to matthewspatrick
Default

Instead of using a page footer, have you tried using a report footer? The report footer will be slotted in after the last detail record or after the last section footer (if you have any section footers, that is).
Reply With Quote
  #3  
Old 12-15-2005, 05:17 AM
Novice
 
Join Date: Oct 2005
Posts: 13
RHall
Default Page Footer Top

MatthewsPatrick,

That worked Thank you very much.

I was trying to use MoveLayout . This is suppose to make the page footer
move up to the next prionting line.

Has anyone got an example on how to use this property.

Thanks in advance.

RHall
Reply With Quote
  #4  
Old 12-15-2005, 06:35 AM
Expert
 
Join Date: Dec 2005
Location: Wilmington, DE - USA
Posts: 275
matthewspatrick
Send a message via MSN to matthewspatrick
Default Re: Page Footer Top

Quote:
Originally Posted by RHall
I was trying to use MoveLayout . This is suppose to make the page footer
move up to the next prionting line.

Has anyone got an example on how to use this property.
That is a runtime property and not a design time property, so I believe you will need code to implement it (I would use an OnFormat event sub for the page footer section).

It interacts with several other runtime properties. Chapter 9 of Litwin et al.'s Access Desktop Developer's Handbook has several pages on how to use it.
Reply With Quote
Reply

Bookmarks

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reset page number and total page number for each group lisadailey Reports 1 03-12-2009 07:55 AM
Access and Web page mahlambane Access 1 11-18-2008 08:43 AM
Totaling a value in group footer... hodgy20 Reports 0 11-14-2008 05:28 AM
Need help with values in the footer allochthonous Reports 0 03-03-2007 05:20 PM


All times are GMT -8. The time now is 08:27 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.