Access Form remove last blank row using AllowAdditions Property

This tutorial explain how to remove last blank row in Access Form using AllowAdditions Property.

Access Form remove last blank row

This is a very quick and short tutorial showing how to remove last blank row in Access Form.

When you create a Access Form, by default, it shows the last record as blank as below, because the blank row is for you to add new record.


To remove the blank row, simply not allow the Form to add any record.

Navigate to Form Property > Data > Allow Additions, change parameter to No.


Now last blank row is removed.


Access Form remove last blank row in VBA

You can use AllowAdditions Property to set Allow Additions to Yes or No. The below code set Allow Additions to No.

Me.AllowAdditions = False

Outbound References


Wyman W
Wyman is a Human Resources professional based in Hong Kong, specialized in business analysis, project management, data transformation with Access and Excel.

He is also a:
- Microsoft Most Valuable Professional (Excel)
- Microsoft Community Contributor
- Microsoft Office Specialist in Access / Excel
- Microsoft Specialist in MS Project
- Microsoft Technical Associate
- Microsoft Certified Professional
- IBM SPSS Specialist

Leave a Reply

Your email address will not be published. Required fields are marked *