Solved

msaccess report group footer overwriting page footer

Posted on 2014-10-10
2
279 Views
Last Modified: 2015-01-10
i have created an Access report with an instruction field at the bottom of GroupFooter1 with Can Grow=Yes.  When the instruction field grows too long it over-writes information in the page footer.  See the attachment.
OrderReportIssue.pdf
0
Comment
Question by:wlreimer
2 Comments
 
LVL 30

Expert Comment

by:hnasr
ID: 40374690
Unable to recreate the issue.
Try to upload a report, with a couple of records to demonstrate the issue. Remove any object not needed to show the problem.
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 40376988
One work around given the style of report (invoice) would be moving the page footer detail to the report footer.

 My other suggestion would be to go through the report and turn off all the special properties; keep together, repeat section, can grow (controls and sections), then add in one at a time to get what you need.   Then turn the can grow back on for the special instructions and for the group footer.  See if that gives you the output you want.

 Often, many of the settings will conflict, giving you what seem to be unpredictable results when it is actually working as it should, but that is the result you get.

 And if not a sample database, a screen shot of the report design would be good.

Jim.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now