Computer Learning Zone CLZ Access Excel Word Windows

There's a new reality born every minute.

-Neil Peart
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
Home > TechHelp > Access >

Back to TechHelp

Single field multi col display Upload Images   Link  
Tiffany Janish 
2 months ago
I am wanting to display the values of a single-field, continuous subform within multiple columns to maximize design space. For example, I have a database training notes form, with a subform to list the objects used/created in that training. But, I want to list the objects into 2 columns within that subform, allowing more room for my dev task subform below that. Thanks for any tips!
Scott Axton
2 months ago
Tiffany We need more information.
A screen shot or two of what you have in mind would be great. Even if you do a mock up in Word or Excel.
Doesn't have to be fancy just an idea of what you're trying to accomplish.
Of course block out any sensitive info or use dummy info.
Tiffany Janish
2 months ago

Tiffany Janish
2 months ago
Hi Scott! Thanks for your message. I have added a mockup of what I am wanting. I would use this is many situations, but this is an example. The TrainingObjectSF is a single field subform that I want to "wrap" and display into multiple columns and have the list scroll if possible Thanks again for any advice!
Kevin Yip
2 months ago
Hi Tiffany, that kind of multi-column display can only be done in reports, not in forms.  To do it in a form, you have to create a dummy table and put your data in it, in the arrangement you want.  This can be done in VBA with recordset operations, not terribly difficult, but certainly not something you would normally do.  I did an example below (see picture).  It took me about an hour (just to give you an estimate on how much work is involved in case you take this job to someone and he says, oh, 6 months).  And if you want to do this yourself, you need VBA and recordset skills.

In my example below, a movie has a long list of cast, and I list them in an "across-and-down" format to make the list shorter:
Kevin Yip
2 months ago

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to TechHelp Comments

Start a NEW Conversation
Only students may post on this page. Click here for more information on how you can set up an account. If you are a student, please Log On first. Non-students may only post in the Visitor Forum.
Subscribe to TechHelp
Get notifications when this page is updated

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

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn