When you create the fields you will notice a section at the bottom of the screen that allows you to change attributes such as the size of the field, the number and date format. To change attributes for a field you will need to click on the field at the top which will give you access to it's attributes displayed in the bottom section of the screen. (Figure 16)

To change the field size of the PostalCode field click on it to select it. As in Figure 16 above a green arrow will appear to indicate that it has been selected. Then click in the white box next to Length. Type in the number of characters you want the field to be restricted to. In this case it is 4.

If you want to change the number or date format click on the grey button next to Format example. This will bring up a dialogue box which will allow you to choose a format for the number or date.

It is important to note that if you change the field size in a table and there is already data captured you may lose some of that data. For example, if you change a field size from 50 characters long to 10 characters long and there is a record with 20 characters in that particular field you will lose the data so be very careful.

Rules can be created for various fields, for example, you may want to restrict a field to be no bigger than 10 characters. This is done by creating a validation rule. Click on Tables and Edit the table.

Click on the field you want to set a rule for. The attributes are displayed at the bottom of the screen.

Sometimes the columns containing the fields are not wide enough to display the data fully. You can widen the columns by opening the table. Click on the table, right click and select Open from the pop-up menu. Move your mouse up between the field names in the grey area (as you would to widen columns in a spreadsheet), double click on the vertical line separator.

FIX ME