Customization of Standard Fields

This sample shows how to change the definition of standard fields.

This sample is based on the Invoice Template with Long Product Description (c4020). Here are the steps to follow to change the standard fields:

1. First, make sure you have made a backup of your current database file.
2. Open your template as usual.
3. Click "Customers" on the ribbon tab.
4. Click "Custom Fields", and then "Advanced..."
5. If you have not backed up your database file yet, click "Backup Database" to do so now.
6. From the "Database Table" list, choose the table you want to modify. The "Fields" section shows the fields defined in this table.
7. Double-click the field you want to modify, or click to select the field, and then click the "Customize" button.
8. Click OK to apply the modification.

Note that if you change the size of the text field, you may also need to change the data validation of the corresponding cell. For example, if you change the size of the customer name field to 80, to change the data validation of the Excel cell, follow the steps below:

1. Push down the "Design Mode" button on the ribbon tab.
2. Click and choose the customer name cell that is named "oknWhoName".
3. Go to the "Data" ribbon tab. Click "Data Validation".
4. Specify the new validation. In this case, you just need to modify the "Maximum" field to 80.
5. Exit design mode.
6. Save the template.