Unresolved:Datasheet hide issue..Help.

[captnk]

Other than having to manually hide/unhide columns in a (subform) datasheet view,is it possible with some CODE to do this on clik of a button etc.
Please help with some code ideas if u think it is possible.
The advantage of hide/unhide in a datasheet is the columns self adjust,whereas forms are fixed in their view.

 

[naygl]

type in "hide column" in Microsoft Access Help's Answer Wizard

 

[captnk]

Tkx.But that tells me how to do it manually,which I mentioned in my post,a nd which of course is easy to do.
(Clik the mouse etc.)
I need to do this automatically from a button.

 

[naygl]

My help has something on the ColumnHidden property. example: Forms!Products!ProductID.ColumnHidden = -1

I'm using Access 2000 by the way.

[This message has been edited by naygl (edited 01-22-2002).]

 

[captnk]

Many tks.
YES!!! u r right I did find it,and it works ok.
All i have to do now is figure out how to unhide it

But at least iam on the way.
Hopefully this solves the final part of my developement