Access Form - Continuous - Display records and go to a second column

Posted on 2014-01-01
Last Modified: 2014-01-04
Hello all,

Strange question but never know til I ask.  

Have a tabbed form.   On one of the tabs I have 2 subforms.  One subform has an input area for inputting the person's name or entity name as well as a listbox to show all names in the system already

The second subform shows all parties that I've input or selected for this record (Continuous Form).

Due to the length of those 2 subforms I can only get 3 or 4 lines on the 2nd subform to display and then the Scroll control shows.  However I have enough room on that 2nd subform that I could get 2 columns across and 3 to 4 rows each.

So, my question.  Is there some way to get a continuous form to display 4 lines tall and then go to a 2nd column and show 4 more lines?  I don't think it can, but I'm not very versed in this Access
Question by:wlwebb
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +2
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 333 total points
ID: 39749688
No. A Continuous form shows a single record at a time, and cannot be shown in "Columnar" view.

You could kludge up a form with multiple subforms - i.e. a form with two subforms side-by-side - and then embed that form in your main form, but keeping track of which record is showing in which subform would be a major PITA.

Author Comment

ID: 39749693
That's sort of what I concluded....  I'll leave open for a while longer to see if anyone else suggests anything different but your comment about multi subforms is all I could come up with too.  AND YES I agree that would be a major PITA
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 333 total points
ID: 39749899
You could also perhaps use a Grid control that's compatible with Access and work something out that way.

However, in my opinion, you might look into reformatting the parent and child forms to make better use of screen real estate. Of course, that's easy to say, but can be quite hard to do :) .

Good luck, and Happy New Year!!
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

LVL 11

Expert Comment

by:Gregory Miller
ID: 39749908
I think this might actually be doable... I was working a project where I was required to create a sub report for transactions by hour of day and I wanted to organize it across the page and wrap instead of in a single column. Here is a screen shot of the report:
screenshotI had fits with it because in looking at the report between the designer mode and the report view mode, it did not work BUT in print preview mode it does work.
Here is the Report View of the same subform:
screen shot2
Here is the design View:
I had to adjust the columns of the parent form as well as the size dimensions of the sub form MANY times before I was able to do what I wanted.

I hope this helps...

Author Comment

ID: 39749917
I'm not following.  Are you bringing a "Report" onto a Form?
LVL 11

Expert Comment

by:Gregory Miller
ID: 39749918
Ooops... got distracted mid read and had reports on my mind...
LVL 30

Expert Comment

ID: 39750089
"go to a 2nd column and show 4 more line" needs clarification.

Upload a sample database and give a scenario to see the issue.
LVL 37

Accepted Solution

PatHartman earned 167 total points
ID: 39750117
Sorry, Access forms do not support this but I wish they did.  I have found several situations where this would have been more convenient.

This doesn't sound like a place where multiple subforms would solve your problem but there are instances where that would work.  A time card for example.  There are only 7 days in the week so you would use 7 subforms; one for each day.  I have also used the technique for comparing things.  Think of those shopping web pages where you can select 5 items and see their specs side by side.  I did a form and a report like that to compare the details for up to 5 investment properties.

Author Closing Comment

ID: 39755792
Thanks all, your comments confirmed my conclusion...

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Familiarize people with the process of utilizing SQL Server views 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 Microsoft Access…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

707 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