You can quickly change the formatting a data sheet by using the AutoFormat feature. XPAC lets you apply an existing format template, or create your own.
To apply an existing formatting template:
| 1. | Open the database that you want to apply a data sheet formatting template to, for example, . |
| 2. | Click on the Tools toolbar. |
| 3. | Select . The window displays. |
| 4. | Select the formatting template that you want to use from the drop-down list. |
XPAC applies the formatting settings to the database data sheet.
To create your own formatting template:
| 1. | Open a database data sheet, for example, a calendar database. |
| 2. | Click on the Tools toolbar. |
| 3. | Select . The window displays. |
| 4. | Type the name of the new formatting template in the field. |
| 5. | Select the cell/s in the sample data sheet that you want to apply formatting to, for example, . |
| 6. | Format the selected cell/s: |
| a. | Click . The window displays. |
| b. | In each tab, specify the formatting settings that you want to apply to the selected cell/s in the sample data sheet, for example, . |
| 7. | If required, adjust the height of selected row/s: |
| a. | Click . The window displays. |
| b. | Specify the height of the selected row/s. Select either: |
| i. | to let XPAC determine the appropriate height for the row/s based on the font size; or |
| ii. | , then specify the height in the specified . |
