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.

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

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

Thanks Graham T and Saintsman!!!

Both of your suggestions work.