Changing Field Properties


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


Display the table in Design view.


Click the field you want to change.


Click the field property box you want to change.


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


Click the Save button on the toolbar.


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


Show Me Microsoft Office Access 2003
Show Me Microsoft Office Access 2003
ISBN: 0789730049
EAN: 2147483647
Year: 2002
Pages: 318 © 2008-2017.
If you may any questions please contact us: