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.

form_last_blank_row

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.

form_last_blank_row_2

Now last blank row is removed.

form_last_blank_row_3

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

https://msdn.microsoft.com/en-us/library/office/ff197373.aspx?f=255&MSPPError=-2147217396

 

Wyman W
Wyman is a Business Analyst based in Hong Kong, specialized in business analysis, project management, and also creating custom Function and Sub solutions, and is proficient in report automation with Access.

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 *