View Single Post
  #2 (permalink)  
Old May 1st, 2005, 01:18 PM
rjweers rjweers is offline
Friend of Wrox
Join Date: Nov 2004
Location: Seattle, WA, .
Posts: 248
Thanks: 0
Thanked 1 Time in 1 Post

The simplest way to accomplish this is to display the form in DataSheet view. Then teach your users how to use Access functionality.

E.g. Right click on a column heading and select "Hide Columns" to hide the column.

E.g. Right click on the form's caption and select "Unhide Columns..." to see a list of available columns to unhide.

Of course they can drag columns to reorder them and use "Freeze Columns" to keep them visible during right horizontal scroll.

No coding necessary!

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
Reply With Quote