Use this procedure to create a stand-alone label (a label that isn't attached to another 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.)). To create a label that's attached to a control, just create the control. Microsoft Access automatically attaches a label to the control when you create it.
Tip Create more impactful forms and reports by using Office Themes in Access 2010! Watch a video or try Office 2010.
- Open 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.) (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.)in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.).
- Click the Label tool in the toolbox (toolbox: A set of tools that is available in Design view for adding controls to a form or report.).
- On the form, report, or data access page, click where you want to place the label, and then type the text for the label.
- If you want to display the text in a label on more than one line on a form or report, you can resize the label after you enter all the text, or you can press CTRL+ENTER at the end of each line of text to enter carriage returns. If you insert a carriage return, Microsoft Access automatically wraps subsequent lines as you type. The maximum width of the label is determined by the length of the first line of text.
- If you want to use an ampersand (&) in a label on a form or report, you must type two ampersands. For example, if you want the text "Products & Suppliers" to appear in a label, type Products && Suppliers. The extra ampersand is necessary because Access uses a single ampersand in a label or button to define an access key (access key: A key combination, such as ALT+F, that moves the focus to a menu, command, or control, without using the mouse.).