The Field Size property determines the maximum size of information that can be stored in a text or number field. For example, if you set the size of a text field to 2, you could enter “MN” but not “Minnesota.” There are several reasons why you would want to change the size of a field:

- Changing the field size to only allow for what is necessary reduces data-entry errors.
- Access can process smaller field sizes more quickly.
- Smaller field sizes require less hard drive storage space.

While Field Size determines the maximum number of characters in a text field, in a numerical field, it determines the number type.

- In Design View, select the field whose size you want to change.
- Click the
**Field Size**box and type or select the field size. If prompted, click**Yes**to complete the action.Be very careful when changing the Field Size of a field that already contains data. Access will truncate or delete data that is larger than the new field size.

Number Field Sizes | |||
---|---|---|---|

Byte | Integers from 0 to 255. | Very small – not usually a good choice. | |

Integer | Integers from -32,768 to 32,767. | Works for most numbers without decimals. | |

Long Integer | Integers from -2,147,483,648 to 2,147,483,647. | Works for most numbers without decimals. | |

Single | Positive or negative numbers up to 38 zeroes and 7 decimal places. | Good for large numbers with decimals. | |

Double | Positive or negative numbers up to 308 zeroes and 15 decimal places. | For really big numbers with decimals. | |

Replication ID | Long unique codes. | Used when you want to merge copies of a database. | |

Decimal | Positive or negative numbers up to 28 zeroes and 28 decimal places. | Good for numbers with a lot of decimals. |