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

btgtech
btgtech used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:

Author

Commented:
Rey -

Can you explain a little more about how the code in the example knows which column to hide?

Author

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?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial