When you create a Form you select the underlying object. A Form can be based on a table, or multiple tables, or a query, or multiple queries. When you create the Form, the controls on the form inherit many properties from the underlying object. For example, if there is a field in the underlying Table that is a Combo Box when you create the Form based on that Table, the control for that field will also be a Combo Box. Forms consist of three main sections: Form Header, Detail section, Form Footer. A Form could also have a sub-Form.
In this post:
1. Adding a control
If when you created the Form you did not add all the fields from the underlying object(s), or you have subsequently added a field to an underlying object, you may need to add a control for that field to your Form. In the below example I am adding a control for the Suburb field in the underlying tblResponses table:
- Select the Design menu
- Drag the Form Footer section down to make space for the new control
- Activate the Add Existing Fields command…
- …to open the Field List
- Left-click drag the Suburb field from the list in the Field List panel and
- drop it on the Detail section of the Form
2. Modifying a control
In this scenario, after adding the Suburb Text Box control to the Form, I then decided to make the Suburb field in the underlying table a Combo Box. I now need my Text Box control to be a Combo Box control on the form:
- Select the Text Box control
- Right-click the control
- Select Change To»Combo Box
3. Adding an Image
You can add an image to any part of the form.
- Activate the Design menu
- Click the Insert Image option
- Browse for an image file or insert a previously used image file
- Left-click drag the image on the form where you want it to appear
4. Adding a Background image
You can add a background image to a Form, or one of the sections of a Form.
- Select the Format menu
- Us the Background Image much as the same way as you used the Insert Image option from the previous section, Adding an Image.
- Use the Property Sheet to tweak the settings of the background image
- For example, I set the Picture Size Mode to Stretch