How to Hide a Column in Access

You can temporarily hide a column when you want to reduce the amount of information on the screen. This doesn’t delete any information—it only hides it.

Hide a Column

1. Click the header for the column you want to hide.
2. Click the More button on the ribbon.
3. Select Hide Fields.
   

Access temporarily hides the column from view.

To hide multiple columns at once, select them all, then right-click one of the selected column headers and select Hide Fields.

Unhide a Column

1. When you're ready to unhide a column, click any column header.
   
2. Click the More button on the ribbon.
3. Select Unhide Fields.
   
4. Click the check box next to each column you want to redisplay.
5. Click Close.
   

Access displays the hidden field once again.