The sizing for DB Label and DB Memo objects behave differently. The size of DB Label object will limit the data that appears on the printed report if the object's size is not large enough. To print more data in the object, you have to make the object wider. We will increase the length of some DB Label objects on the report.
To change the height and width of the DB Label column objects:
| 1. | In the "Report Designer" window, click on the DB Label object for CustomerCompany. |
Handlebars appear on the selected object.
| 2. | Click on the handlebar in the middle of the right edge of the selected object, then drag it to the right until the size of the field is 3 inches in size. |
Using the [Shift] + [Left]/[Right] arrow keys, you can also modify the width of the selected object. When comparing the exact location, height, and width measurements for multiple objects use the coordinates, Left, Top, Width, and Height, for the selected objects, which are located in the status bar across the bottom of the Report Designer.
| 3. | Using the [Shift] + [Down] arrow key, to increase the height of the DB Label CustomerCompany object so the bottom of the letters like "g" and "y" can be seen. Repeat this step for the other DB Label objects, so all of the height for the DB Labels objects are set to 0.1771. Repeat this step as well for the Label objects, so all of the height for the Labels objects are set to 0.1771. |
| 4. | Change the width of the CustomerLastName DB Label object to about 2 inches, the Slogan DB Label object to about 3.5 inches, and the TotalCharge DB Label object to about 1.5 inches. The CustomerCompany DB Label object should already be about 3 inches. |
We will want the Place column object to automatically wrap to another line if necessary as multiple lines may be in the data field.
| 5. | Right click on the Place DB Memo object, to access the context menu, and select the "Stretch" option. This will increase the height of the object when more text is present than the size of the object. |
After placing all of the column objects in the Detail section, align the column objects vertically. Then, align each column object with it's corresponding text object, ensuring the report is printed evenly.
To align objects vertically:
| 1. | In the "Report Designer" window, click on the column object for TotalCharge. Press and hold the [Shift] key, then click on the column objects Place, Slogan, CustomerCompany, and CustomerID. Do not select the column object CustomerLastName. |
The column objects are enclosed in red handlebars.
| 2. | From the "Align or Space" toolbar, choose "Align Left". |
The selected objects are lined up along the left edges.
| 3. | Click outside the objects to deselect them. |
To align text and column objects:
| 1. | In the "Report Designer" window, Click on the text object for ID/Last name. Press and hold the [Shift] key, then click on the column objects CustomerID and CustomerLastName. |
The objects are enclosed in red handlebars.
| 2. | From the "Align or Space" toolbar, choose "Align Top". |
The selected objects are lined up along the top edges.
| 3. | Click outside the objects to deselect them. |
Use the previous procedures to align each the rows of text and column objects.
Before you make any more changes, preview the layout of the report.
