manipulate datasheet (of a form)

[TNL]

Hi,

how can I manipulate a datasheet programmatically, for example: hide a
column, The datasheet is a form in sheet view?

thanks
TNL

 

[Glenn]

In the form onopen event:

Me.[Fieldname].ColumnHidden = True

Rgds,
Glenn

 

[TNL]

Thanks

In the form onopen event:

Me.[Fieldname].ColumnHidden = True

Rgds,
Glenn

-----Original Message-----
Hi,

how can I manipulate a datasheet programmatically, for example: hide a
column, The datasheet is a form in sheet view?

thanks
TNL





.

 

[TNL]

And, can I access the property of the columns in datasheet view.
For example: the users changes the order of the columns with drag and drop
(original on the form, colum ID is the 1., col Name is the 2., but on
datasheet, the user change: col Name is the 1.)... I want print data in the
order as the user changed.

Thanks

In the form onopen event:

Me.[Fieldname].ColumnHidden = True

Rgds,
Glenn

-----Original Message-----
Hi,

how can I manipulate a datasheet programmatically, for example: hide a
column, The datasheet is a form in sheet view?

thanks
TNL





.