Locked lesson.
About this lesson
Make modifications to the way the form looks and behaves by switching it to Single form view.
Exercise files
Download this lesson’s related exercise files.
7.03 modifying-the-form - Exercise.docx54.4 KB 7.03 modifying-the-form - Exercise solution.docx
92.5 KB TechGurusTicketing15.accdb
744 KB TechGurusTicketing15 - Complete.accdb
748 KB
Quick reference
Modifying a Form
Delve deeper into form customization and modify key fields to change how the form behaves.
When to use
Customize a form whenever you want to control the look, feel, and behavior of a form.
Instructions
Form Properties
- Right-click on the tab and select Design View.
- Right-click on any field and select Form Properties from the menu.
Single view vs Continuous
- From the Property Sheet, on the Format tab, change the Default View from Continuous to Single Form.
- Right-click on the tab and select Form View.
Single Form shows the company fields in one field. Continuous view shows them in a long list. Single Form is much less wasteful of space.
To navigate through the records, use the record selector icons at the bottom of the screen. New records can be added from here also.
Fields added in this way can be edited and modified in the same way as when using Continuous Forms.
Filtering records
Records can be filtered in Single Form view.
- From the Home tab, in the Sort & Filter group, click Filter.
- Select 'Abacus' and 'Calypso' from the list.
- Click OK.
Toggle the filter off by clicking the Filtered button at the bottom of the screen.
Searching for records
- Click in the search field in the records selector.
- Type 'Calypso' and press Enter.
Enabling Datasheet View
When using Single Form view, Datasheet view is not enabled by default. We can turn this on if we want to allow users to edit records in Datasheet view.
- Right-click on the tab and select Design View.
- From the Property Sheet, toggle the Allow Datasheet View field to Yes.
Lesson notes are only available for subscribers.