In the Report Wizard, the text and column field objects are sized to best fit the report. However, since the data contained in the columns vary in length, for example area codes with three digits, we can shorten the area code fields.
To shorten the area code object:
| 1. | In the "Report Designer" window, click on the DB Label column object for EmployeeAreaCode in the Detail section. |
Handlebars appear on the selected object and the Edit toolbar displays two drop down boxes, one containing the table name and another for the column name, EmployeeAreaCode. The status bar displays the name of the selected object, DB Label.
| 2. | Press the [Shift] key and select the text "Area Code". |
Red handlebars appear on the selected objects. With the Corporate style and red background, you may not easily see the red handlebars.
| 3. | Press the [Shift] + [Left Arrow] keys to shorten the length of the items together. |
| 4. | Press the [Ctrl] + [Right Arrow] key to move the items to the right. |
| 5. | Click elsewhere in the workspace to deselect the objects. |
The objects were made smaller and left some room to increase the last name object. Now, we'll adjust the size of the last name object.
To lengthen the last name object:
| 1. | In the "Report Designer" window, click on the DB Label column object for EmployeeLastName. |
Blue handlebars appear on the selected object.
| 2. | Press the [Shift] + [Right Arrow] keys to increase the length of the item. |
| 3. | Choose File: Save to save changes to the report. |
