In Microsoft Access, there’s a function referred to as Freeze that allows the person to preserve an space of a datasheet seen whereas scrolling to one other space; you should use the freeze function to freeze a number of fields in your desk, question, type, view, or saved process in the datasheet. The sector that you just freeze will transfer to the left place of the datasheet.
How to Freeze and Unfreeze columns in Access
Observe the steps under to Freeze and Unfreeze Columns in Microsoft Access:
- How to Freeze columns in Microsoft Access
- How to Unfreeze columns in Microsoft Access
- Transfer the sphere to the unique place
1] How to Freeze columns in Microsoft Access
In Microsoft Access, there are two strategies to freeze a column or subject.
Technique 1 is to click on the header of the column or subject you need to freeze.
Click on the Extra button in the Data group and choose Freeze Fields in the drop-down menu.
The column or subject is frozen, and the sphere that you just freeze will transfer to the left place of the datasheet.
Restore down the Access window and attempt to scroll to the correct, and you’ll discover that the frozen column just isn’t transferring.
Technique 2 is to right-click the header of the column or subject, then choose Freeze Fields from the drop-down menu.
2] How to UnFreeze columns in Microsoft Access
Technique 1 is to click on the header of the column or subject you need to freeze.
Click on the Extra button in the Data group and choose UnFreeze All Fields in the drop-down menu.
Technique 2 is to right-click the header of the column or subject, then choose UnFreeze All Fields from the drop-down menu.
How to transfer the column or subject to the unique place in Microsoft Access?
To maneuver the column or subject to its unique place in a Microsoft Access datasheet; place the cursor on the backside line of the column till you see a four-sided arrow, and drag it over to its earlier place. Be certain that you unfreeze the column earlier than doing this as a result of whether it is Freezed, it gained’t transfer.
We hope this tutorial helps you perceive how to use Freeze and Unfreeze columns in MS Access; if in case you have questions concerning the tutorial, tell us in the feedback.
What occurs to the place of a subject if you unfreeze it?
In the event you unfreeze the sphere(s) or column(s) of a Microsoft Access desk or datasheet, you’ll have to transfer the column(s) again to their unique place. Or else, simply don’t save the adjustments when closing the Microsoft Access datasheet. When you’ll re-open your Access file, the fields or columns will stay in their earlier positions.
