Link to home
Start Free TrialLog in
Avatar of btgtech
btgtechFlag for United States of America

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of btgtech

ASKER

Rey -

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

ASKER

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?