Locked lesson.
About this lesson
Adjust the properties of the form using the Property Sheet and Form Properties.
Exercise files
Download this lesson’s related exercise files.
7.02 form-properties - Exercise.docx43.4 KB 7.02 form-properties - Exercise solution.docx
107.3 KB TechGurusTicketing14.accdb
744 KB TechGurusTicketing14 - Complete.accdb
748 KB
Quick reference
Form Properties
Understand the difference between Form Properties and the Property Sheet.
When to use
We use Form Properties whenever we want to make a change to the overall look, feel, and behavior of the form as opposed to a specific field on the form.
Instructions
Form Design
- Right-click on the tab.
- Select Design View from the menu.
In Design View, each form has three sections: a header, details, and a footer.
The form header will be assigned a default name based on the name of the form. We can change this to make it more meaningful.
- Click in the form header.
An orange border will appear around the outside of any fields currently being edited.
- Type 'Companies List'.
The Property Sheet
Each part of a form can be customized using the Property Sheet. We can control the style, the formatting, and the behavior of each element.
- Click on the Company field in the Details section of the form.
- From the Form Design tab, in the Tools group, click Property Sheet.
Notice that the selection type for this field is Text Box. The Control Source is the field or table that will populate this field.
- Scroll down to Font Size.
- Change the font size to 18pts.
We can view any changes we make by switching back to Form View. Form View is how the form will be seen by the user.
- From the Home tab, in the Views group, click View.
- Select Form View.
The font will now display in 18pts.
Form Properties
- From the Home tab, in the Views group, click View.
- Select Design View.
- Click on the Company field.
- Right-click and select Form Properties.
Form Properties control the overall look and feel of the form as opposed to the individual fields. The Record Source will show the table that is in use in this form.
Changing the Sort Order
When we added 'Discover Inc' to our list of companies, it appeared out of sequence i.e. not in alphabetical order. We can force the form to always list the countries alphabetically by changing the sort order.
- From the Property Sheet, click the Data tab.
- In the Order By field, type 'Company'.
- From the Home tab, in the Views group, click View.
- Select Form View.
'Discover Inc' is now in the correct position in the list.
- Click in the last blank row.
- Add a new record for 'DataWorld'.
- Click Save.
- From the Home tab, in the Records group, click Refresh All.
The records are now sorted alphabetically.
Hints & tips
- Press ALT+Enter to open the Property Sheet.
Lesson notes are only available for subscribers.