?
Solved

Subform "Column Choose" Functionality

Posted on 2016-11-08
3
Medium Priority
?
56 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 49

Accepted Solution

by:
Dale Fye earned 2000 total points
ID: 41878632
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
ID: 41878801
Perfect - thanks!
0
 
LVL 49

Expert Comment

by:Dale Fye
ID: 41878812
glad I could help
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Suggested Courses
Course of the Month13 days, 23 hours left to enroll

807 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