Formatting database fields

When you design a database table and create the fields for the table, you can also format the fields for such properties as:

and other format properties, depending on the data type of the field.

This is the field formatting level. (See Field data types for information on data types and their associated formatting properties.)

Once you have designed your table and gone to Table Grid View - where you can begin to enter data - each field corresponds to a column. The formats you have set for fields determine how data is displayed in the columns.

However, there is another level of formatting available that can only be applied once you are in Table Grid View. Like the field formats, these formats also apply to the columns in your table and work alongside the corresponding field formats. These include font style and size, background and foreground color, text color, alignment, and border styles (see Formatting columns in a database table for more information).