Show All

Make a subform look like a datasheet that displays a header and footer

You can display a form header and footer on a subform and arrange the text boxes and other controls so that the subform looks like a datasheet when you open the form in Form view.

1. Open the form that you want to use as the subform in Design view.
2. If you haven’t already added a form header and footer, on the View menu, click Form Header/Footer.
3. In the detail section, arrange the text boxes and other controls that display data in a single row.
4. In the form header, arrange the labels for the text boxes and other controls. Make sure that you align the labels in the form header with their associated controls in the detail section.
5. In the form footer, if you want to total the records in the subform, create calculated controls.
6. Size each section appropriately. For example, make the detail section the size of one row in a datasheet. If you don’t have any controls in the form footer, set its Height property to 0 or set its Visible property to No.
7. Double-click the form selector to open the property sheet for the form.
8. In the DefaultView property box, click Continuous Forms. This setting displays records in a form one after another, similar to a datasheet.

Notes

• When you set DefaultView to Datasheet, Microsoft Access hides the header and footer when you display the form in Form view.
• The Quarterly Orders form in the Northwind sample database has a continuous subform that has a form header and footer and looks like a datasheet. To view this form, point to Sample Databases on the Help menu, click either Northwind Sample Database or Northwind Sample Access Project, and then open the Quarterly Orders form in Design view.