How to Freeze and Unfreeze columns in Microsoft Access
In Microsoft Access, there is a feature chosen Freeze that enables the user to keep an area of a datasheet visible while scrolling to some other surface area; you can use the freeze feature to freeze one or more fields in your table, query, form, view, or stored procedure in the datasheet. The field that you freeze will motion to the left position of the datasheet.
How to Freeze and Unfreeze columns in Access
Follow the steps below to Freeze and Unfreeze Columns in Microsoft Access:
- How to Freeze columns in Microsoft Admission
- How to Unfreeze columns in Microsoft Access
- Movement the field to the original position
i] How to Freeze columns in Microsoft Access
In Microsoft Admission, there are ii methods to freeze a column or field.
Method i is to click the header of the cavalcade or field you desire to freeze.
Click the More button in the Records group and select Freeze Fields in the driblet-down card.
The column or field is frozen, and the field that you freeze will move to the left position of the datasheet.
Restore down the Admission window and try to coil to the right, and you will find that the frozen column is not moving.
Method 2 is to right-click the header of the cavalcade or field, then select Freeze Fields from the drop-down menu.
2] How to UnFreeze columns in Microsoft Access
Method 1 is to click the header of the column or field you want to freeze.
Click the More push button in the Records grouping and select UnFreeze All Fields in the drop-down carte.
Method two is to right-click the header of the column or field, then select UnFreeze All Fields from the drop-downwards menu.
How to motion the column or field to the original position
To move the column or field to its original position; identify the cursor at the bottom line of the column until you encounter a iv-sided arrow, and drag information technology over to its previous position; ensure that you unfreeze the cavalcade earlier doing this because if it is Freezed, it won't move.
We hope this tutorial helps you empathise how to utilise Freeze and Unfreeze columns in MS Access; if you lot take questions about the tutorial, allow us know in the comments.
What happens to the position of a field when yous unfreeze it?
If yous unfreeze the field or column, yous will have to motion the column dorsum to the original position or do not save changes when closing Access, and when reopening your Access file, the fields will remain in their previous position.
How do y'all unfreeze a field?
Microsoft Access enables users to unfreeze the column later on freezing information technology. We volition explain the procedure of how to unfreeze the cavalcade in Access.
Source: https://www.thewindowsclub.com/freeze-and-unfreeze-columns-in-access
Posted by: martinezishaves.blogspot.com
0 Response to "How to Freeze and Unfreeze columns in Microsoft Access"
Post a Comment