Access DataSheet Forms

In this article I will explain how to create datasheet forms in access.


What is it?

Datasheet forms are forms that look like an Access table (a datasheet):
Result


How to?

Step 1:
Click on the Form Wizard button on the Create Ribbon:
Form Wizard

Step 2:
Choose the fields you would like to be displayed in the datasheet form:
Choose Fields
Step 3:
Select the datasheet layout:
DataSheet
Result:
As you can see the table looks exactly like a table:
Result
You can download a sample Access file with a datasheet form from the link below:

If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website  www.software-solutions-online.com

Leave a Reply

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