Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Help   Contact   Merch   Join   Order   Logon   Forums   
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Access Reporting
Ronald Bella 
     
2 years ago
I am building a report in MS Access.   In Page Setup I define the report as a single column however I have positioned data aligned in three separate columns.   The report defines the organization’s applicable pay rates for twelve states.  Some states have only one pay rate for all counties.  Other states have as many as 3 to 10 counties with COLA adjusted rates.   Our biggest state occupies the entire third column given it has so many counties with adjusted rates.   The data for each state consists of a heading, a subheading and a subreport.

I have a State heading and subheadings immediately beneath the heading for each state.  I tried the Can Grow and Can Shrink logic in the form but I found Access’ placement of my data as unpredictable when I did things this way.  Thus, I have measured the individual length of a subreport, one by one as I placed data on the report.  

My problem:   The very last state in column 2 which is occupied by seven states, measures out perfectly that the heading for this state should be at 8.9 inches on a 12-inch page.  Yet the heading and its data instead prints at around 10.5 inches.  I have searched for hidden objects or line breaks.   All headings are copies of the first and thus contain no element not contained in all others.  The same is true of the subheadings.   The width of my subreports are identical at 2.25 inches.   My headings are a little smaller at 2.1667 inches.  I can see no reason why this one subreport and its heading should behave any different than the five immediately before it.  I can’t help but think the problem is in placement of the heading given its subheading and subreport are found in their proper location in relation to the heading but the heading is too low.  

I also attempted to place the headings within the individual reports themselves.  Yet I continue to get a huge space in column 2 between either the next to the last and last state or in the case of the placement with headings inside the subreport, one state earlier.  

Any ideas of where to look for my problem?    
Richard Rost  @Reply  
          
2 years ago
This is difficult to troubleshoot without being able to see it. Can you post some screen shots of the design and print preview? Use sample data, of course.
Richard Rost  @Reply  
          
2 years ago
In the meantime, here's what GPT has to say:

Your problem seems to be related to the positioning of your controls and possible misalignment or unintended growth of elements in your report. Here are some potential areas to investigate and steps to troubleshoot:

1. Hidden Controls or Margins:
   - Ensure there are no hidden or invisible controls in the section where the issue occurs. Even invisible controls with `Can Grow` enabled can affect spacing.
   - Check the margins and padding settings for the report and the individual sections. Misconfigured margins could cause unintended spacing.

2. Section Properties:
   - Verify the `Can Grow` and `Can Shrink` properties of the sections (not just the controls). If a section like the detail or footer has `Can Grow` enabled, it may inadvertently add space.
   - Check if you have any empty or unnecessary sections (like footers or headers) in the main report or subreports that might be contributing to the spacing issue.

3. Alignment of Controls:
   - Confirm that all headings, subheadings, and subreports are perfectly aligned and have no overlapping boundaries. Misaligned controls can cause Access to add extra space.
   - Use the Arrange tab in the report design view to ensure consistent alignment.

4. Subreport Properties:
   - Make sure each subreport's `Can Grow` and `Can Shrink` properties are set correctly. A subreport with `Can Grow` enabled may push content down if it calculates additional space for its contents.
   - Check the subreport's height explicitly in design view and compare it with the reported measurement.

5. Static and Dynamic Sizing:
   - If you've manually measured and set sizes for each subreport, confirm that no subreport's actual data is causing it to exceed the predefined height.
   - Temporarily replace the problematic subreport with a placeholder (like a box of the same height) to see if the issue persists.

6. Parent Report Detail Section:
   - Inspect the `Force New Page` property for the controls and sections in your main report. Ensure no unexpected page breaks or section breaks are causing the misalignment.
   - Check for any `Keep Together` settings, which might be forcing an entire heading and subreport block to move to the next column.

7. Corrupted Layout or Report:
   - Sometimes, Access reports can behave unpredictably due to corruption in the design. Try creating a new blank report and copying the controls and settings to it.
   - Avoid copying the problematic state block until you've verified the layout works correctly.

8. Debugging Placement:
   - Temporarily add border outlines to the headings, subheadings, and subreports to visualize where Access is placing each control. This can help identify if any unexpected spacing occurs due to specific elements.

9. Sorting and Grouping:
   - Check the sorting and grouping levels for the report. If a grouping has incorrect or unnecessary settings (e.g., group headers/footers with spacing), it might contribute to the problem.

If the problem persists, consider testing with just the problematic state and a few others in a simplified report. This will help isolate whether the issue is specific to one control, state, or subreport configuration.
Ronald Bella OP  @Reply  
     
2 years ago
This helped immeasurably.    Thank you.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 8/17/2026 9:58:13 AM. PLT: 1s