Create a bound text box

Create a bound text box

  1. Open a form in Design view, a report in Design view, or a data access page in Design view.

  2. Click Field List on the toolbar. The field list appears. In a form or report, if the field list button or command isn't available, you need to bind the form or report to a recordsource. If the field list is empty in a data access page, you must connect the page to a database.

  3. Do one of the following:
    To select Do this
    One field Click the field.
    A block of fields Click the first field in the block, hold down the SHIFT key and click the last field in the block.
    Nonadjacent fields Hold down the CTRL key and click the name of each field that you want to include.
    All fields Double-click the field list title bar.

    To select Do this
    One field Click the field.
    A table or query Click the Wizard tool in the toolbox if it's not already pressed in, and then click the table or query.
  4. Do one of the following:

    Note   You must drag the field or fields from the field list. If you click the field or fields in the field list and then click the form, report, or data access page, Microsoft Access won't create the control.

    Access places one text box on the form, report, or data access page for each field that you select in the field list. Each text box is bound to one field in the underlying data source. Each text box also has an attached label by default.

  5. Size the text box so that it's the appropriate size for the data you want to show.

  6. Change the label text if necessary.

  7. Switch to Form view, Datasheet view, Page view, or Print Preview to test the control.

Note   For text boxes on forms that have many lines of text, you may want to add a vertical scroll bar.

How?