Show hidden columns in Datasheet view

1. Open a table, query, form, view, or stored procedure in Datasheet view.
   
   
2. Click Unhide Columns on the Format menu.
   
   
3. In the Unhide Columns dialog box, select the names of the columns that you want to show.

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