Note: Access also places a label to the left of the text box, so leave some room to the left of the pointer for the label. Position the pointer where you want the text box to be placed on the form or report, and then click to insert the text box. On the Design tab, in the Controls group, click Text Box. Open the form or report in Design view by right-clicking the form or report in the Navigation Pane, and then clicking Design View. It is easiest to add an unbound text box in Design view. You can use an unbound text box to display the results of a calculation or to accept input that you don't want to store directly in a table. Add an unbound text boxĪn unbound text box is not connected to a field in a table or query.
You can also add a bound text box to a form or report by first adding an unbound text box, and then setting the Control Source property of the text box to the field you want to bind it to. In the Field List pane, expand the table containing the field that you want to be bound to your text box.ĭrag the field from the Field List pane to the report or form.įor more information about working with the Field List pane, see the article Add a field to a form or report. On the Design tab, in the Tools group, click Add Existing Fields. Open the form or report in Layout view or Design view by right-clicking the form or report in the Navigation Pane, and then clicking the view you want. Add a bound text box to a form or report by dragging a field from the Field List pane If you drag an OLE Object field to a form or report, Access creates a bound object frame, and if you drag an attachment field to a form or report, Access creates an attachment control. For example, if you drag a Yes/No field from the Field List pane to a form or report, Access creates a check box. Note: Beginning in Access 2013, Text data types have been renamed to Short Text and Memo data types have been renamed to Long Text.ĭragging fields of other data types creates different types of controls. Access automatically creates a text box for fields of the following data types: The changes that you make in the text box will be reflected in the underlying table.Ī quick way to create a bound text box is by dragging a field from the Field List pane onto your form or report. On a form, you can use a text box that is bound to an updatable record source to enter or edit data in a field. What do you want to do?Ī bound text box displays data from a field in a table or query.
Access 2013 label wizard how to#
This article explains how to create and use a text box and also explains some important text box properties.
Many different types of data can be displayed in text boxes, and you can also use them to perform calculations. The text box is the standard control in Access used for viewing and editing data on forms and reports.
0 kommentar(er)
