Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Access
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Delete a control or another item
 
  1. Do one of the following:

    Select the control or controls that you want to delete.

    ShowHow?

    In a form or report, if the control (control: A graphical user interface object, such as a text box, check box, scroll bar, or command button, that lets users control the program. You use controls to display data or choices, perform an action, or make the user interface easier to read.) has an attached label (label: A control that displays descriptive text, such as a title, a caption, or instructions, on a form, report, or data access page. Labels may or may not be attached to another control.), it looks like this:

    Selected control with an attached label in form or report

    Callout 1 Move handles

    Callout 2 Sizing handles

    Callout 3 Attached label

    Callout 4 Selected control

    In a data access page (data access page: A Web page, published from Access, that has a connection to a database. In a data access page, you can view, add to, edit, and manipulate the data stored in the database. A page can also include data from other sources, such as Excel.), if the control has an attached label, it looks like this:

    Selected control with an attached label on a data access page

    Callout 1 Move handles

    Callout 2 When the pointer changes to an open hand, you can drag the control.

    1. Open a form, report, or data access page in Design view.
    2. Do one of the following:
      • To select one control, click anywhere in the control.
      • To select adjacent controls, click at any point outside a control, and drag a rectangle over the controls that you want to select.
      • To select nonadjacent or overlapping controls, hold down the SHIFT key and click each control that you want to select.

      Note  In a data access page, you can't select more than one control unless you have installed Microsoft Internet Explorer 5.5 or later.

    3. If you want to remove one or more controls from the selected group, hold down the SHIFT key, and then click the controls that you want to remove.

    Note  If you click a control that's already selected, an insertion point appears inside the control so that you can enter or edit text. To reselect the control, click outside the control, and then click the control again.

    Show Tip

    You can specify whether the rectangle that you drag over controls needs to only touch the controls or must enclose them completely to select them. On the Tools menu, click Options, click the Forms/Reports tab, and then click one of the options under Selection Behavior.

    Select the field, text, macro (macro: An action or set of actions that you can use to automate tasks.) action, or other item that you want to delete.
  2. Press DELETE.

Note  If you are deleting a control that has an attached label, Microsoft Access deletes the control and its label. If you want to delete just the attached label, click the label and press DEL.

advertisement