How to easily and quickly change width of columns?

[rgrstvr]

I have a file with 45 columns and I need to be able to make 40 columns quickly dis-appear and re-appear. When I search for responses to similar questions I get references to "Horizontal scroll bar and List Box control" which I do not know how to find and/or use.

[Bob Fitz]

I have a file with 45 columns and I need to be able to make 40 columns quickly dis-appear and re-appear.

W
Are these columns being shown in datasheet form.

[June7]

Code behind form can hide controls. This is fairly simple. Can use a Toggle control click event.

Me.textboxname.Visible = Me.togglecontrolname


In Datasheet view, column widths can be changed. http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

Me.textboxname.ColumnWidth = -2

[rgrstvr]

I am in Datasheet view. I followed the instructions in http://msdn.microsoft.com/en-us/libr...ffice.11).aspx. The only format menu I can find is under the Fields tab and nothing responds to my clicks on the various items in that format menu.

[June7]

The link was for Access 2003. Access 2007 has ribbon, not menu bar. I see nothing on ribbon to change column display width or hide columns.

However, the VBA code is the same. Not sure how you want to execute the code. Buttons do not show on forms in datasheet view.