United States
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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. Copy or move a control or other item
Applies to: Microsoft Office Access 2003
You can copy or move items such as fields, controls (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.), text, or macro actions (action: The basic building block of a macro; a self-contained instruction that can be combined with other actions to automate tasks. This is sometimes called a command in other macro languages.). When you copy a field, control, or macro action, Microsoft Access includes any associated properties, controls, or action arguments (action argument: Additional information required by some macro actions. For example, the object affected by the action or special conditions under which the action is carried out.). For example, when you copy a text box control, Access copies its label as well. When you copy a macro action by clicking the row selector (row selector: A small box or bar that, when clicked, selects an entire row in table or macro Design view, or when you sort and group records in report Design view.), Access copies the associated action arguments, macros, and conditional expressions (conditional expression: An expression evaluated and compared to a value; for example, If...Then and Select Case statements. If the condition is met, one or more operations are performed. If it isn't met, the operation is skipped.). However, Access doesn't copy event procedures (event procedure: A procedure that is automatically executed in response to an event initiated by the user or program code, or that is triggered by the system.) associated with a control. When you select an item and then use the Copy or Cut command, Microsoft Access replaces the contents of the Clipboard with that item. As long as the item is stored on the Clipboard, you can paste it wherever and whenever you want. Also, if you are in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.) of a form, report, or 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.), you can use the Duplicate command to create a copy of a control without replacing the contents of the Clipboard.
Notes You can use the Microsoft Office Clipboard to collect and paste multiple data items such as records or groups of records, or the contents of fields or controls. However, you cannot use the Office Clipboard to collect items such as controls, macro actions, or database objects. To a limited extent, you can determine where Microsoft Access pastes a control. If you select a section, Access pastes the control in the upper-left corner of the section. If you select a control near the area where you want to paste the control, Access pastes the control just below the selected control. Note, however, that if you paste a label on a form or report, and the control that you select doesn't have an attached label, Access attaches the label to the selected control.
|
Email this link
Printer-Friendly Version
Share
Show All
Hide All
on the toolbar.
on the toolbar.
on the toolbar.| Related Web Sites |
| ||||||
