Hide Datasheet column

[John M]

I have a subform which i chose to display in datasheet format. I set a particular field's property to hidden but it still appears in the datasheet. Is this a limitation of Access or am I doing something wrong here.

Thanks in advance.

 

[Graham T]

John

ColumnHidden Property

You can use the ColumnHidden property to show or hide a specified column in Datasheet View.

Datasheet view:

For example, you might want to hide a CustomerAddress field that's too wide so you can view the CustomerName and PhoneNumber fields.

Note: The ColumnHidden property applies to all fields in Datasheet view and to form controls when the form is in Datasheet view.

Setting:

You can set the ColumnHidden property by clicking Hide Columns or Unhide Columns on the Format menu in Datasheet view.

Visible Property

The Visible property has no effect on a column in Datasheet view. To specify whether a column is visible in Datasheet view, you use the ColumnHidden property.


From Access Help Files

HTH

 

[saintsman]

You can also hide columns by clicking on the column header and dragging it until it disapears (the opposite of enlarging it to fit the contents of a field).

 

[John M]

Thanks Graham T and Saintsman!!!

Both of your suggestions work.