Changing Field Properties

graphics/microsoft88_1.gif

After you create fields in a table, you can specify properties that define the field's appearance or behavior in the database. In Design view for tables, Access provides a list of field properties for each data type. The properties list changes depending on the data type. Some of the field text properties include Field Size, Format, Input Mask, Caption, Default Value, Validation Rule, Validation Text, Required, Allow Zero Length, and Smart Tags.

Change Field Properties

graphics/1_icon.jpg

Display the table in Design view.

graphics/2_icon.jpg

Click the field you want to change.

graphics/3_icon.jpg

Click the field property box you want to change.

graphics/4_icon.jpg

Type or change the value, or click the list arrow, and then select a value or option.

graphics/5_icon.jpg

Click the Save button on the toolbar.

graphics/6_icon.jpg

When you're done, click the Close button in the Table window.

graphics/04inf05.jpg



Show Me Microsoft Office Access 2003
Show Me Microsoft Office Access 2003
ISBN: 0789730049
EAN: 2147483647
Year: 2002
Pages: 318

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net