Report with two sections using multiple subforms

Hello,

I would like to create a report with multiple subfroms that can be used to control the display area. Unfortunately, my current solution is not working as I intented. If the row of subform spans multiple rows, this pushes the other forms down. Is there a better solution for this problem. The screenshot might be a better help to understand my problem than  my writing.
Rep2Section.png
repTwoSection.JPG
LVL 1
shydocAsked:
Who is Participating?
 
Nick67Commented:
This is the one limitation of Access that really cannot be overcome with any kind of effective simplicity.
Access reports are intended to grow DOWNWARD.
The minute you decide that you'd like a report with fairly complex and variable length data to be presented like Word, with a couple of tables side-by-each, you have opened up a world of hurt.
You can use columns as @Jim suggested, but getting consistent side-by-side pleasing looks to varied data is very, very difficult.

I won't say impossible, and I rarely do, but in this case probably NOT worth the tremendous effort that would be involved.
Simple data, where the various text items don't vary much can be dealt with, with varying levels of success.
Complex data, not so much
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
I think you'd be better off to use multiple columns and let it flow from one column to the next as needed.

Your subforms  would be the width of a column (say two columns, each half the page)

Jim.
0
 
shydocAuthor Commented:
Thank  Jim, I will investigate further on columns.

Thanks Nick for clarifying the limits of the Access capability, at least now I can confidently inform my client that is not doable if Jim's suggestion doesn't pan out.
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.