Access 2007 Report Output has Overlap and Gaps - Subform Problem?

I am using Access 2007.  When viewing a report, some fields overlap each other, others have huge gaps.  I am attaching 1 Design View and 2 Report Views.  On each subform/subreport, I have selected "Can Grow" from the Property Sheet (it's selected by default).

 This is the report design
 partial report - note overlap
 continuation of report - note gaps
In Design, I have selected Arrange and clicked "To Fit", and other options to no avail.

Can anyone help me with this problem?

Thank you!
LVL 1
flashinglemurAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeOwner, Dev-Soln LLCCommented:
You also need to se the "Can Shrink" property to True or Yes.
Jeffrey CoachmanMIS LiasonCommented:
Does the happen in Print Preview?

A few things to try:
1. Do you really need the (blue) header section in each of the subreports? (if not, shrink it to 0 Height)
2. Set the "Can Grow" Property of the subreports to Yes

...other than that, this will be difficult (for me at least) to diagnose, without having a sample that displays this issue.

Sample database notes:
Back up your database(s).
Combine the front and back ends into one database file.
Remove any startup options, unless they are relevant to the issue.
Delete any objects that do not relate directly to the issue.
Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
Compile the code. (From the database window, click: Debug-->Compile)
Run the compact/Repair utility.
Remove any Passwords and/or security.
Post explicit steps to replicate the issue.
Test the database before posting.

In other words, ...post a database that we can easily open and immediately see the issue.

Thanks

JeffCoachman
Dale FyeOwner, Dev-Soln LLCCommented:
You might also want to get rid of the labels that are associated with each of the subreports, and put those labels in the report header section of the actual subreport.  That way, they float with the subreport, and are not overwritten by the previous subreport as it expands.
Bootstrap 4: Exploring New Features

Learn how to use and navigate the new features included in Bootstrap 4, the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first websites.

flashinglemurAuthor Commented:
Hello FYED.  Had set shrink to yes as a test.  No good.

Also, agree on the labels. Was going to take care of that once this problem was resolved.

Hi Jeff.

Print Preview first notes, "The section width is greater than page width, and there are not items in the additional space, so some pages may be blank."

Organizations is truncated on page one.  Page 2 has a little blue in the upper left corner, but that's it.  Page 3 looks correct starting with Assistance Type.

"Can Grow" is set to yes for each field.  Is there another place you wanted me to set that?

Thank you!

flashinglemurAuthor Commented:
Changed width.  Now it prints on two pages.  Ugh. Now Group Community Actions TITLE is there, but no data field box.
flashinglemurAuthor Commented:
So Report View does look different from Print Preview, Report View is still squished together, Print Preview had cut off the last field (but not title).
Dale FyeOwner, Dev-Soln LLCCommented:
Try adjusting the width of all of the subforms so that they are the same width.  Set their left property to 0 and width to whatever the width of the report is.

I've got a report that has about a 8 subreports, one right below the next.  All have the same width (although they don't all print all the way across the form), and have CanGrow and CanShrink set to Yes.
Jeffrey CoachmanMIS LiasonCommented:
And how about that sample dB file...

This will save us a lot of our valuable time spent guessing...

;-)

Jeff
flashinglemurAuthor Commented:
Okay, here is a stripped down version of the program, with confidential information replaced.

- Open Switchboard form
- Choose "Generate Assistance Report"
- Start date: 1/1/04
- End date: 12/31/04
Click report button

You will now see the report, along with the overlapping and gapped formatting.  Please note this needs to work correctly in Access 2007.

Thank you for all your help!
exchange.zip
Dale FyeOwner, Dev-Soln LLCCommented:
Is this more like what you had in mind?

- I moved most of the labels into the subreport Report headers
- Removed most of the column labels, as those seemed self explanitory
- Changed the width on all the reports to the same width, Set CanGrow and CanShrink on each report to Yes
- aligned each subreport right below the previous subreport
exchange.accdb
flashinglemurAuthor Commented:
fyed.  Thank you for your hard efforts.

When I look at the report view from 1/1/2004 to 12/31/2004, I see the following in 2007 (I'm on another PC. both have the latest updates):


newreport1.JPG
flashinglemurAuthor Commented:
oops, wasn't finished. meant to show you it's still overlapping.  Are you using 2010 or 2007?  If I view in print preview, it does not overlap.  However, users may wish to view a screen report.  Here's the bottom of the report...


newreport2.JPG
Jeffrey CoachmanMIS LiasonCommented:
First, lets be clear on how the Report is being opened.

If you look at the "Macro" that opens this report, it opens it in "Report View"
Please change this to "Print Preview" and you will see this anomaly does not manifest itself.

I am not quite sure why MS set this view as the Default, as it is not a valid representation of how the report will actually look when "Printed".
So my guess is that even when this anomaly occurred, if you actually printed the report, it would print fine.

Report view:
Displays a "Quick" overview of the Report
(no complex Graphics, no code, no page breaks, ...etc)
But it will allow for "interaction" (Click Buttons, activate Hyperlinks, Sorting, ...etc)

IMHO, unless you have a specific reason for needing Report View, always change the default view of your reports to "Print Preview". (also set all your code and macros that open your Report to "Print Preview")
(I even go as far as setting the: "Allow Report View" property of the Report(s) to NO)

;-)

JeffCoachman

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dale FyeOwner, Dev-Soln LLCCommented:
Concur with Jeff.  I never event checked the ReportView, I automatically go to Print Preview.
flashinglemurAuthor Commented:
I'm gonna have to go with that.  Here's the kicker... It aligns perfectly in 2010, which I initially created the dB in. Ugh.  So thanks for your help and I'll split the points.  Take care!
flashinglemurAuthor Commented:
Strange things happen when reverting back from 2010 to 2007. But I really appreciate the help of these two gentlemen.
Jeffrey CoachmanMIS LiasonCommented:
Since 2010 is newer, it may have fixed this "Bug" in 2007?...
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.