Solved

Subform "Column Choose" Functionality

Posted on 2016-11-08
3
19 Views
Last Modified: 2016-11-08
I have a standard Access form with a subform drawing fields from a Project table. The table itself has about 25 fields and the subform is showing about 5. There has been a request to allow end-users to select the fields they want to show on the subform.

Is there a common best-practice way to do this? I though about toggling the .visible property but think that would leave holes where the not-visible fields are.

Any input is welcome!

MV
0
Comment
Question by:Michael Vasilevsky
  • 2
3 Comments
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 500 total points
Comment Utility
You could use a datasheet as the subform, which would allow the users to hide or drag columns into the position you want them in.  I actually have an article on how to do this, located here.
0
 
LVL 10

Author Closing Comment

by:Michael Vasilevsky
Comment Utility
Perfect - thanks!
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
Comment Utility
glad I could help
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of utilizing SQL Server functions 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 Ac…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

744 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now