Allow user to select fields in a form (at runtime) to see in Access 2010

Posted on 2012-03-19
Medium Priority
Last Modified: 2012-03-20

I am using Microsoft Access 2010 with vba running in the background.

I will be using a continuous form to present the data to the user.  I would like for the user to choose what fields to view at runtime.  I have ideas on how to do this,  but I would like some considered opinions.

Question by:peispud
LVL 15

Accepted Solution

Simon Ball earned 1000 total points
ID: 37736876
Listbox and select button.

listbox contains field names and multiselect mode on

when button pressed, use VBA to loop through listbox contents.  if selected, set field control to visible., if not, set field to invisible..
LVL 77

Assisted Solution

peter57r earned 1000 total points
ID: 37736878
At a simple level, you can set the visible property to No for controls you don't want to see but in a continuous form you will still see the gap where the field would appear if it were visible.

If you are able to use form datasheet view instead then you can set each columns 'hidden' property in the Form_Open event procedure ,like...

Me.Fieldname.ColumnHidden = True
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37738479
Do you really need a truly "Open Ended" system here...?

Most situations require 2 or 3 different combinations of fields, ...In this case you can simply create separate forms, and be done with this.

If this is a "Security" issue, then you will probably need something a lot stronger that simply "hiding" the Columns...
LVL 44

Expert Comment

ID: 37738525
peispud:  This question is now over 8 hours old and  you have been asked a few questions - may I request your answers?

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

624 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