How To Change Field Size In Access 2016

The Field Size holding determines the maximum size of information that tin be stored in a text or number field. For example, if you lot set the size of a text field to 2, you could enter "MN" but not "Minnesota."

The Field Size belongings

At that place are several reasons why y'all would want to change the size of a field:

• Changing the field size reduces data-entry errors.

• Access can process smaller field sizes more than quickly.

• Smaller field sizes require less hard-bulldoze storage space.

Field sizes work a little differently for text and number fields. In text fields, the Field Size property determines the maximum number of characters the field can accept, every bit shown in figure. In numbers fields, the Field Size property determines what type of number the field volition accept.

In this lesson y'all will modify the size of a table's fields.

1. If necessary, open the Lesson iv database and double-click the tblCustomers table.

   In order to modify the field size, you lot must be in Design view.

2. Click the View button on the toolbar.

   The table appears in Design view. You probably already know the offset step by nowclick the name of the field whose property you want to change.

3. Click the State field.

   Now change the State'due south field size.

4. Click the Field Size box in the Field Properties section and type 2.

   The Country field can now only accept a maximum of 2 characters. Users will now have to enter standard two-digit state abbreviations.

   Let'southward endeavor changing the size of some other field.

5. Click the ZipCode field.

   Observe that the ZipCode's field size is fix at 50. We probably won't accept any 50-digit Zip Codes for at least a few more than years, so you can safely modify the field size to a smaller number.

6. Click the Field Size box in the Field Properties section and type 11.

   The ZipCode field will now take no more 11 digits.

   Be very careful when you're changing the Field Size of a field that already contains information. Access volition truncate or delete information that is larger than the new field size.

7. Click the Save push on the toolbar to relieve your changes, click Yeah to ostend the change, and close the table.

If you are working with a number field, the Field Size property determines the blazon and size of the number that a field will accept, equally shown in tabular array.

Available Number Field Sizes

Heading	Number Range	Decimal Places	Storage Size
Byte	0 to 255	None	1 byte
Integer	-32,768 to 32,767	None	2 bytes
Long Integer	-two.1x1038 to two.1x1038	None	four bytes
Single	-three.4x1038 to 3.4x1038	7	iv bytes
Double	-ane.8x10308 to one.8x10308	15	8 bytes
Replication ID	North/A	Due north/A	16 bytes

How to change the field size:

1. make sure the table is displayed in pattern view.

2. select the field whose size you desire to change.

3. click the field size box in the field properties section.

4. for text fields: type the field size value.

   for number fields: cull the value from the list.

by updated Sep 02, 2017

Source: https://brainbell.com/tutorials/ms-office/Access_2003/Changing_The_Field_Size.htm

Posted by: woodsbobviscep.blogspot.com

Share this post