Simplifying Data Entry by Using Forms

To create a form based on a table by using the Form tool

  1. Open the table on which you want to base the form.

  2. On the Create tab, in the Forms group, click the Form button.

To move labels on a form

  • Select the labels to be moved by dragging through them, drag them to a blank section of the form, and then release the selection.

To change the font and font size of a label on a form

  1. Open the form in Design View, and click the label (not its text box) you want to change.

  2. On the Design contextual tab, in the Font group, click the Font arrow, and then in the list, click the font you want to use.

  3. With the label still selected, click the Font Size arrow, and then in the list, click the size you want.

To edit form control properties by using the Property Sheet pane

  1. Open the form in Design view, and if the Property Sheet pane is not visible, right-click the desired control, and then click Properties.

  2. In the Property Sheet pane, click the property you want to change, and either type the new value, or click the down arrow and select the value you want. Repeat for all properties that you want to change.

To edit multiple form control properties at once

  1. Click anywhere in the Detail section of the form, and then drag diagonally to draw a rectangle through some portion of all the controls to select them.

  2. In the Property Sheet pane, click the property you want to change, click the arrow that appears, and then click the option you want. Repeat for all properties that you want to change.

To set the background properties of all controls on a form

  1. Select all the controls on the form. Then on the Format tab of the Property Sheet pane, click Back Style, and set it to the option you want.

  2. Click Back Color, and then click the ellipsis button.

  3. In the Color Builder, click the square of the color you want.

  4. Set the Special Effect property to the option you want, and the Border Color property to the color you want.

To edit the caption of a form control

  • Click the label whose caption you want to change. Then in the Property Sheet pane, click the Caption property, change the text to what you want, and press .

To change the layout of controls on a form

  • Drag through all the controls on the form to select them. Then on the Arrange tab, in the Control Layout group, click the Remove button.

To delete a form control label

  • Click the label you want to delete, and then press the key.

To select specific control labels on a form

  • Hold down the key as you click each control or drag through just the labels you want to select.

To align form controls

  • Select the labels (but not their corresponding text boxes), and then in the Property Sheet pane, set the Text Align property to the alignment you want.

To size form control labels to fit their contents

  • Select the labels to be sized, and then on the Arrange contextual tab, in the Size group, click the Size To Fit button.

To insert space between form control labels and text boxes

  • Select all the text boxes (but not their corresponding labels). Then in the Property Sheet pane, click the Left property, and then change the setting to the amount of space you want.

To save the design of a form

  • On the Quick Access Toolbar, click the Save button.

To expand the Detail area of a form

  • Point to the right edge of the form Detail grid, and when the pointer changes to a double-headed arrow, drag the edge of the background to the right.

To move a label or text box control on a form

  • Click a label or text box, move the pointer over its border, and when the pointer changes to a four-way arrow, drag it to a new location.

To create an AutoFormat form template

  1. On the Arrange contextual tab, in the AutoFormat group, click the AutoFormat button.

  2. At the bottom of the AutoFormat gallery, click AutoFormat Wizard.

  3. In the AutoFormat dialog box, click the Customize button.

  4. In the Customize AutoFormat dialog box, click Create a new AutoFormat based on the Form option, and then click OK.

  5. In the New Style Name dialog box, type a name for the new style, and then click OK.

  6. Click OK to close the AutoFormat dialog box. Then click the Save button, and close the form.

To add a graphic to a form control

  1. In the Navigation Pane, under Forms, right-click the form you want to use, and then click Design View.

  2. On the Design contextual tab, in the Controls group, click the Image button, and then click the area where you want to place the image, drag diagonally to draw a rectangle, and release the mouse button.

  3. In the Insert Picture dialog box, navigate to the folder where the graphic you want to use is located, and then double-click the graphic.

To add a caption below a picture

  1. In the Controls group, click the Label button, and then drag diagonally to draw a rectangle where you want it to appear.

  2. In the active label control, type the caption text, and then press .

To size a label control to fit the text

  • Click the label control, and then on the Arrange tab, in the Size group, click the Size to Fit button.

To add a combo box control without using a wizard

  1. On the Design tab, in the Controls group, look at the Use Control Wizards button. If the button is active (orange), click it to deactivate it.

  2. In the Controls group, click the Combo Box button, and then drag diagonally in the form to draw a rectangle where you want the combo box to appear.

To copy the formatting of one control to another

  • Click the box whose formatting you want to copy, and in the Font group, click the Format Painter button. Then click the box to which you want to apply the formatting.

To remove the record selector and scroll bar controls from a form

  1. In Design view, click the Form selector (the box at the junction of the horizontal and vertical rulers), and then press to display the Property Sheet pane for the entire form (if the sheet is not already displayed).

  2. On the Format tab, change Record Selectors to No, and Scroll Bars to Neither.

To create a form based on the fields in a table by using the Form wizard

  1. In the Navigation Pane, under Tables, click the table in which you want to create the AutoForm.

  2. On the Create tab, in the Forms group, click the More Forms button, and then in the list, click Form Wizard.

  3. With the open table selected in the Tables/Queries list, click the Move All button to move all the table fields to the Selected Fields list, and then click Next.

  4. On the second page of the wizard, choose the layout of the fields in the new form. On the third page, select a style option.

  5. On the fourth page, with the Open the form to view or enter information option selected, click Finish.

To create a form and subform simultaneously

  1. On the Create tab, in the Forms group, click the More Forms button, and then click Form Wizard.

  2. On the first page of the Form wizard, in the Tables/Queries list, click the table on which you want to base the form. Then click the Move All button to include all the table fields in the new form.

  3. To create the subform, display the Tables/Queries list, and then click the table on which you want to base the subform.

  4. In the Available Fields list, double-click the fields you want to include in the subform to move them to the Selected fields list, and then click Next.

  5. With your primary table and Form with subform(s) selected, click Next.

  6. With Datasheet selected, click Next.

  7. On the last page of the wizard, select a style, and then click Finish.

To add a subform to a form

  1. Open the form in Design view. Then on the Design tab, in the Controls group, make sure the Use Control Wizards button is active (orange).

  2. In the Controls group, click the Subform/Subreport button, and then drag diagonally to draw a rectangle in a section where you want to put the subform.

  3. On the Subform wizard’s first page, with the Use existing Tables and Queries option selected, click Next.

  4. In the Tables/Queries list, click the type of item you want to use.

  5. Add fields to the Selected Fields list by double-clicking each field. Then click Next, select the options you want, and click Finish.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset