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

Chapter 4. Working with Fields > Setting Field Size

Setting Field Size

For Text, Number, and AutoNumber data types, you can use the Field Size property to set the maximum size of data stored in the field. In the case of text data, this property specifies the number of characters allowed (from 0 to 255). Numeric field sizes include Byte, Integer, and Long Integer options for integer values, and Single and Double options for decimals. The difference between these sizes lies in the amount of storage space they use and the range of possible values they cover. If your integers will cover only the range 0 to 255, you should use Byte, but for a larger range you should use Integer or Long Integer.

Specify Field Size

Display the table in Design view, and then click the text or numeric field in the field list.

Click the Field Size box in the properties sheet, and then either type the Field Size value (for text fields) or choose the value from the drop-down list (for numeric fields).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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