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.

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

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.

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).]

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 http://www.access-programmers.co.uk/ubb/smile.gif
But at least iam on the way.
Hopefully this solves the final part of my developement