Open a table, query, form, view, or stored procedure in Datasheet view.
Select the column(s) you want to hide.
To select one column, click the field selector for that column.
To select adjacent columns, click a column field selector and then, without releasing the mouse button, drag to extend the selection.
On the Format menu, click Hide Columns.
Notes
For information on showing hidden columns, click .
You can't save datasheet formatting changes to a datasheet in a Microsoft Access project unless it is a form. If you need to save formatting changes to an Access project table, view, or stored procedure datasheet, use the AutoForm Wizard to create the datasheet as a form (which quickly sets the RecordSource property to the datasheet and adds all the fields to the form), and then set the form's DefaultView and ViewsAllowed properties to Datasheet (which makes the form behave like a datasheet).
.