Computer Learning Zone CLZ Access Excel Word Windows

The cure for boredom is curiosity. There is no cure for curiosity.

-Dorothy Parker
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to TechHelp    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Single field multi col display
Tiffany Janish 
    
4 years 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  @Reply  
        
4 years 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 OP  @Reply  
    
4 years ago

Tiffany Janish OP  @Reply  
    
4 years 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  @Reply  
     
4 years 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  @Reply  
     
4 years ago

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

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: 5/1/2026 7:24:51 PM. PLT: 0s