In general, using the Field List pane is the easiest way to add a field to a form or report. Top of Page Add a field to a form or report without using the Field List

To display the property sheet for a control, click the control to select it, and then press F4. The control remains bound to the field, but you might have to set some properties to make the new control type work the way you want. Otherwise, Access displays a list of control types.Ĭlick one of the available control types to change the control to that type. If the Change To menu item is unavailable, there are no other control types that are appropriate for this field. Right-click the control you want to change, and then click Change To. Open the form or report in Design view by right-clicking it in the Navigation Pane and then clicking Design View. For example, you can change a combo box to a text box or a list box, but you can't change a combo box to a command button.Ĭhange a control from one type to another However, you can only change it to a control type that is appropriate for that field. If you want a field displayed in a different type of control other than the one that Access creates automatically, you can change the control to another type. Then, you can edit the label in the same way that you would edit text in a document. You can edit the label by clicking it once to select it, and then clicking it again to place the insertion point in the label. In addition, Access creates an attached label for the control. Note: This technique can only be used on fields in the Fields available for this view section of the Field List pane.Īccess creates the appropriate control to display each field, and also binds the control to the field. To show or hide the list of fields in each table, click the plus ( +) or minus sign ( -) next to the table name. In the Field List pane, find the table containing the field you want to add. On the Design tab, in the Tools group, click Add Existing Fields. If the Field List pane is not displayed, do one of the following:

Open your report in Layout view or Design view. What do you want to do?Īdd a field to a form or report by using the Field List paneĪdd a field to a form or report without using the Field List If you do not have an existing form or report to add a field to, see Introduction to forms or Introduction to reports to help you get started. When you double-click a field in the Field List pane (or if you drag a field from the list to your form or report), Microsoft Access automatically creates the appropriate control to display the field - for example, a text box or check box - and then binds the control to that field. You can quickly add fields to a form or report by using the Field List pane. Access for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007 More.

Powerchurch how to add footnote