FIELD SIZE :
This indicates the length of the field. If the field is a TEXT field, you can set the field size. For the other data types, the field size is set for you. For Text fields, the default length is 50 positions. You can have a maximum of 255 characters in a text field.
This indicates how you want the information to appear when it is displayed or printed. The Format property affects only how the data is displayed, not how it is stored in the table.
The input mask defines a standard pattern for determining how data is entered into a field. The input mask allows you to set up formats for Social Security Numbers, Telephone Numbers and Zip Codes. The input mask can be applied to fields with data types of text, number, data/type and currency.
The caption is the name that appears in the field headings at the top of the table. The default is the field name as you typed it into the structure. The caption only refers to what is displayed in the field heading at the top of the table in datasheet view, and does not change the name of the field as it is stored internally in the structure of a table.
SWITCHING BETWEEN OBJECT VIEWS
To switch between Datasheet View and Design View, click on the View Button. In order for this to work, you actually have to either be in the records (Datasheet View) and in the design (Design View).
DELETING A FIELD
INSERTING A FIELD
A new field will be added at that location; existing fields will move down.
MOVING A FIELD TO ANOTHER LOCATION
CHANGING THE COLUMN WIDTH IN DATASHEET VIEW
There are two ways you can change the column width in datasheet view:
No Comments for this page.