Hide columns in the datasheet part of a split form

[Abbas]

I have created a split form in Access 2007; I have added a number of fields
to this form; some are bound to the source table and some are not. All the
fields are displayed in the both form pane and the datasheet part.

Is there a way to hide or show selected fields (columns) in the datasheet? I
know you can hide them manually on the form.

Thanks for your advice.

Abbas

 

[fredg]

I have created a split form in Access 2007; I have added a number of fields
to this form; some are bound to the source table and some are not. All the
fields are displayed in the both form pane and the datasheet part.

Is there a way to hide or show selected fields (columns) in the datasheet? I
know you can hide them manually on the form.

Thanks for your advice.

Abbas

Select the datasheet column by clicking in the column header.
Then right-click and select Hide Column.

To unhide the column click anywhere off of the datasheet table (on the
background).
Select Unhide Columns and place a check in whatever columns you wish
to show. You can also use this to hide columns by unchecking the
column here.

 

[Abbas]

Thanks for your reply; but I want to hide/show colums 'programatically';
sorry the word was missed out in my previous post.

thanks
Abbas

 

[fredg]

Thanks for your reply; but I want to hide/show colums 'programatically';
sorry the word was missed out in my previous post.

thanks
Abbas

Look up the ColumnHidden property in VBA help.

 

[Abbas]

Thanks Fred; used the follwoing comamnd and it worked perfectly.

Me.cmbBox.ColumnHidden = True