Advance form controls
1. Change a lookup field to a text field.
2. View and print database documentation
3. Create datasheet, multiple items, and split forms
4. Modify a form and anchor form controls in Layout view
5. Plan, design, and create a custom form in Design view and in Layout view.
6. Select, move, alilgn, resize, delete, and rename controls in a form.
7. Add a combo box to a form.
8. Add form headers and footers to a form.
9. Add a combo box to a form to fine records.
10. Add a subform to a form
11. Add calculated controls to a form and a subform
12. change the tab order in a form
13. Improve the apearance of a form
Important points.
1. To create a custom form you can modify an existing form or
design and create a form from scratch.
2. The record source property specifies the table or query that
provides the fields for the form
3. A bound control is linked, or bound, to a field in the
underlying table or query.
4. An unbound control is not linked to a field in the
underlying table or query.
5. An unbound control that displays text is called a label.
6. A combo box is a contrl that provides the features of a text box and a list
box.
7. The row source property specifies the data source
for a control in a form or report or for a field in a table or query.
8. The Documenter is use to create detailed documentation of
all, or selected, objects in a database. - In tools group, on the design tab
click Relationship Report or click database tools, click database documenter,
select what you want to document.
9. The datasheet tool creates a form in a datasheet format that
contain all the field in the source table or query. double-click Create tab on
the rigon, click more forms, click datasheet.
10 The multiple items tool crates a customizable form tht
display multiple records from a source table or query. click create, in forms
group click multiple items.
11. The split form tool creates a customizable form that
displays the data in a form in both form view and datasheet view at the same
time. Click create, in forms group click Split form.
12. Layout view options on the format tab for a form and
datasheet.
| Group | Form is Active | Datasheet is Active | |
| Font | Selected option applied to the selected labels and text boxes | Selected option applied to every field value in the datasheet. | |
| Formatting | Selected option applied to the selected text box, which must b a currency, data, or number field | Selected option applied to ever field value in the active column, which must be a currency, date, or number field | |
| Gridlines | Selected options applied only to the form, except for the add existing fields button, which applies to both the form and the datasheet. | Only the options in the gridlines list apply to the entire datasheet. | |
| Controls | All options applied only to the form, except for the add exiwting fields button, which appliess to both the form and the datasheet. | Options do not apply in t datasheet, except for the add existing fields button, which applies to both the form and the datasheet. | |
| Autoformat | Selected choice applied only to the form | not available | |