Friday, March 29, 2024
HomeWINDOWSHOW-TOHow to freeze and unfreeze columns in Microsoft Access

How to freeze and unfreeze columns in Microsoft Access

-


V Microsoft Access, there is a function called Freeze which allows the user to keep the visible area of ​​the table when scrolling to another area; you can use the freeze function to freeze one or more fields in a table, query, form, view, or stored procedure in a table. The pinned field will move to the left position of the table.

How to freeze and unfreeze columns in Access

To freeze and unfreeze columns in Microsoft Access, follow these steps:

  1. How to freeze columns in Microsoft Access
  2. How to unlock columns in Microsoft Access
  3. Move the field to its original position

1]How to freeze columns in Microsoft Access

There are two methods for freezing a column or field in Microsoft Access.

Method 1 – click the heading of the column or field that you want to freeze.

Click the icon More v Recordings group and select Freeze fields in the drop-down menu.

The column or field is frozen, and the docked field is moved to the left position of the table.

Restore down access window and try scrolling to the right and you will notice that the docked column doesn’t move.

Method 2 is to right click on the column or field header and then select To freeze Fields from the drop-down menu.

2]How to unlock columns in Microsoft Access

Method 1 – click the heading of the column or field that you want to freeze.

Click the icon More in the Recordings group and select Unfreeze all fields in the drop-down menu.

How to freeze and unfreeze columns in Microsoft Access

Method 2 is to right click on the column or field header and then select Unfreeze all fields from the drop-down menu.

How to move a column or field to its original position

To move a column or field to its original position; position the cursor on the bottom row of the column until you see a four-way arrow, and drag it to its previous position; make sure you unfreeze the column before doing this, because if it is frozen it will not move.

We hope this tutorial helps you understand how to use Freeze and Unfreeze Columns in MS Access; if you have any questions about the tutorial, let us know in the comments.

What happens to the position of the field when you defrost it?

If you unfreeze a field or column, you have to move the column back to its original position, or not save changes when you close Access, and when you reopen the Access file, the fields will remain in their previous position.

How to defrost a field?

Microsoft Access allows users to unfreeze a column after it is frozen. We will explain the procedure on how to unfreeze a column in Access.



Source link

windows789.com

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular