Access 2010: Create code to automatically hide columns in a Datasheet View in Access

We have an Access Application where we are using a Datasheet Form for managing a schedule.  There are quite a few columns, and we do have the functionality on the form for the User to show and hide columns.

Is there a way to build code so that when the user selects a button that the columns and rows are hidden and filter to create a view that is repeatable?
btgtechAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
0
 
btgtechAuthor Commented:
Rey -

Can you explain a little more about how the code in the example knows which column to hide?
0
 
btgtechAuthor Commented:
I would really like to understand how the code in the example knows which column to hide?

Is there a limit to the number of columns that it will hide?
0
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.

All Courses

From novice to tech pro — start learning today.