Part 3 of "Keeping Your Information Accurate in Access 2003 and Access 2002": Using the field size property to restrict data

   Setting         Description
   ------------------------------------------------------------------------

   Byte            Stores numbers from 0 to 255 (no fractions).

   Integer         Stores numbers from -32,768 to 32,767 (no fractions).
 
   Long Integer    (The default.) Stores numbers from -2,147,483,648 to
                   2,147,483,647 (no fractions).

   Single          Stores numbers from -3.402823E38 to -1.401298E-45 for 
                   negative values and from 1.401298E-45 to 3.402823E38 
                   for positive values.

   Double          Stores numbers from -1.79769313486231E308 to
                   -4.94065645841247E-324 for negative values and from 
                   1.79769313486231E308 to 4.94065645841247E-324 for 
                   positive values.

   Decimal         Stores numbers from -10^28 -1 through 10^28 -1 (.mdb).

   Replication ID  Globally unique identifier (GUID). A 16-byte field used
                   in an Access database to establish a unique identifier
                   for replication. GUIDs are used to identify replicas, 
                   replica sets, tables, records, and other objects. In an
                   Access database, GUIDs are referred to as Replication 
                   IDs.

1. Open the Field Test database that you created in Part 2 of this series of articles. For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
   311168  (http://support.microsoft.com/kb/311168/EN-US/ ) ACC2002: Keeping Your Information Accurate: Part 2: Using the Data Type to Restrict Data
2. Open the Field Property Test table in Design view.
3. Click in the TextField row, and in the Field Properties section, change the Field Size property to 12.
4. Click in the NumberField row, click the Field Size property, click its down arrow, and then click Byte in the drop-down list.
   
   You have just restricted the number of characters that can be entered in the text field to 12 and the values that can be entered in the number field to the range 0 to 255.
5. Click the View button to return to Datasheet view, clicking Yes when prompted to save the table.
   
   The table contains data that doesn't fit these new property settings, so Access displays a warning, that some data might be lost:
   
   
   Collapse this imageExpand this image

   
6. Click Yes to acknowledge the risk, and click Yes again to accept the deletion of the contents of one field.
   
   Your datasheet now looks like this:
   
   
   Collapse this imageExpand this image

   
   
   
   TextField now contains only 12 characters, rather than the 32 you entered. The other 20 characters have been permanently deleted. NumberField is empty. Because it is now limited to whole numbers from 0 through 255, the value of 500 that you entered has been deleted.
7. Type 2.5 as the NumberField entry, and press ENTER to see what happens.
   
   The number is rounded down to the nearest whole number.
8. Save and close the table, and then close the database.

Back to the top

ADDITIONAL RESOURCES

Back to the top