Changing Field Properties

graphics/microsoft87.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/one_icon.jpg

Display the table in Design view.

graphics/two_icon.jpg

Click the field you want to change.

graphics/three_icon.jpg

Click the field property box you want to change.

graphics/four_icon.jpg

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

graphics/five_icon.jpg

Click the Save button on the toolbar.

graphics/six_icon.jpg

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

graphics/12inf31.jpg

graphics/12inf32.jpg

Did You Know?

You can set the number of decimal places . Another way to set the number of decimal places for numeric fields is to specify the number of decimal places in the Decimal Places box in the list of field properties.

You can use different formats for different values . Access allows you to specify different formats for positive, negative, zero, and null values within a single field. Use online Help for more information.



Show Me. Microsoft Office 2003
Show Me Microsoft Office 2003
ISBN: 0789730073
EAN: 2147483647
Year: 2002
Pages: 418

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