note on the bottom of first page

Hi Experts,

I have a report with 10 sub reports. the first 5 sub reports are often on page 1. But some times there are more records so the last sub report are moved to the next page. I also have a footer that can't be higher do to some layout restrictions.

Now to the question:

A have a label that should always be at the bottom of page 1. How do i insure that?
And if the last sub report is on top of the label at the bottom, then it should be moved to the next page. Is this possible?
DCRAPACCESSAsked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
The issue here is that any solution should account for this "Label" to be on any sheet (and not hardcode it for page one or two)

If it were me I would simple Group the report on the individual Records (The Primary Key) and then set this "Lable" as a Textbox, and put it in the Groupfooter.

This is why we need you to tell us a bit more about the design and layout of the Report.
Also explain the logic behind why this "label" must only appear on page 1 or 2.

If possible, post a sample DB

Sample database notes:
1. Back up your database(s).
2. Combine the front and back ends into one database file.
3. Remove any startup options, unless they are relevant to the issue.
4. Remove any records unless they are relevant to the issue.
5. Delete any objects that do not relate directly to the issue.
6. Remove any references to any "linked" files (files outside of the database, Images, OLE Files, ...etc)
7. Remove any references to any third party Active-x Controls (unless they are relevant to the issue)
8. Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
9. Compile the code. (From the database window, click: Debug-->Compile)
10. Run the compact/Repair utility.
11. Remove any Passwords and/or security.
12. Post explicit steps to replicate the issue.
13. Test the database before posting.

In other words, ...post a database that we can easily open and immediately see the issue, and if applicable, also include a Graphical representation of the Exact results you are expecting.

JeffCoachman

 
0
 
MikeMcEvoyCommented:
Use the page footer instead of the report footer and set it to only display on page one.

A similar question:Print page footer only on the first page
http://www.access-programmers.co.uk/forums/showthread.php?t=194970
0
 
DCRAPACCESSAuthor Commented:
Hi MikeMcEvoy,

That is not possible since there should always be a page number as the last thing showing on each page. So i can't hide the report footer after page 1.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.