• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 31. Creating a Table > Setting the Field Size and Format

Setting the Field Size and Format

If the field data type is text, you can set the number of characters allowed and specify formatting rules. If the field data type is a numeric value, you can choose the range of numbers to be accepted and the number of decimal places to be stored.

To set the field size and format:

1.
On the Tables tab of the Database window, choose a table and click the Design button.

2.
In the Table window, click the name of the field to format (Figure 31.26).

Figure 31.26. Set the field size and format for a field.


3.
Click the Field Size text box and then enter a number if the field is text, or choose from the drop-down list of options if the field is numeric or some other data type. See Table 31.1 for some Number Field Size options.

4.
Click the Format box; some text and memo data type file symbols are shown in Table 31.2.

5.
Save the changes to the table design.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint