How to Hide or Unhide Fields and Rulers in Microsoft Access

In Microsoft Access, a field is a piece of information related to a single person or thing. Related fields are grouped to form a record, while the ruler changes the format of your reports or forms. To view the ruler in Access, the user must open the report or form in the Design view. Sometimes users in Access would want to hide some fields from their database table or hide the rulers from their forms or reports in Design View.

How to Hide or Unhide Fields and Rulers in Microsoft Access

In this tutorial, we will explain the procedure to hide and unhide fields and reports in Microsoft Access.

How to hide and unhide Fields in Access

There are two methods to hide fields in Access.

Method 1: Open an Access database file.

How to Hide or Unhide Fields and Rulers in Microsoft Access

Right-click the heading of the column that you want to hide.

In the context menu, select Hide Fields.

The column will disappear.

To unhide the field, Right-click the heading of a column.

In the context menu, select Unhide Fields.

An Unhide Columns dialog box will appear.

Check the checkbox for the field you have hidden.

Then close the box.

Method 2: Click the heading of the column that you want to hide.

Click the More button in the Record group and select Hide Fields from the menu.

To unhide the fields, click the heading of a column.

The Unhide Columns dialog box will appear.

Check the checkbox for the field you have hidden.

The field will reappear.

How to hide and unhide Rulers in Access

Open a report or form access file.

Then right-click the form or report and select Design View.

Click the Arrange tab.

Click the Size Spacing button in the Sizing and Ordering group.

Select Ruler from the drop-down menu, and the Ruler will disappear.

To unhide the Ruler, follow the same procedure and select Ruler again.

We hope this tutorial helps you understand how to hide and Unhide Fields and Rulers in Microsoft Access; if you have questions about the tutorial, let us know in the comments.

How to Hide or Unhide Fields and Rulers in Microsoft Access

Source link

Alice AUSTIN

Alice AUSTIN is studying Cisco Systems Engineering. He has passion with both hardware and software and writes articles and reviews for many IT websites.

Leave a Reply