In Microsoft Access, a area is a chunk of data associated to a single particular person or factor. Associated fields are grouped to type a document, whereas the ruler adjustments the format of your experiences or types. To view the ruler in Access, the person should open the report or type in the Design view. Typically customers in Access would need to conceal some fields from their database desk or conceal the rulers from their types or experiences in Design View.

How to Hide or Unhide Fields and Rulers in Microsoft Access

On this tutorial, we’ll clarify the process to conceal and unhide fields and experiences in Microsoft Access.

How to conceal and unhide Fields in Access

There are two strategies to conceal fields in Access.

Technique 1: Open an Access database file.

Proper-click the heading of the column that you really want to conceal.

Within the context menu, choose Hide Fields.

The column will disappear.

To unhide the sector, Proper-click the heading of a column.

Within the context menu, choose Unhide Fields.

An Unhide Columns dialog field will seem.

Verify the checkbox for the sector you have got hidden.

Then shut the field.

Technique 2: Click on the heading of the column that you really want to conceal.

Click on the Extra button in the Report group and choose Hide Fields from the menu.

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

The Unhide Columns dialog field will seem.

Verify the checkbox for the sector you have got hidden.

The sector will reappear.

How to conceal and unhide Rulers in Access

Open a report or type entry file.

Then right-click the shape or report and choose Design View.

Click on the Prepare tab.

Click on the Dimension Spacing button in the Sizing and Ordering group.

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

To unhide the Ruler, comply with the identical process and choose Ruler once more.

What’s F12 in Access?

F12 is used to save the present object with a brand new title. Urgent the F12 key in Microsoft Access opens the Save As dialog field. Now, it can save you your object with one other title. The Save As dialog field may also be opened by urgent the Alt + F keys. Should you press the F12 key with the Shift key, it saves your database object and when you press the Ctrl + F12 keys, it’s going to open an present database.

What does F11 do in Access?

The F11 key in Microsoft Access is used to present or conceal the Navigation Pane. The F11 key can also be used with the Alt key in Access. The Alt + F11 key mixture in Microsoft Access is used to change between Visible Primary Editor and the beforehand energetic window.

We hope this tutorial helps you perceive how to conceal and Unhide Fields and Rulers in Microsoft Access; if in case you have questions in regards to the tutorial, tell us in the feedback.



Source link

Share.
Leave A Reply

Exit mobile version