Overriding the Field Properties of Tables
Access uses the table's property values assigned to the fields as defaults. The form or subform inherits these properties from the table or query on which the form is based. You can override the inherited properties, except for the Validation Rule property, by assigning a different set of values in the Properties window for the control. Properties of controls bound to fields of tables, or queries that are inherited from the table's field properties are shown in the following list:
Format
Decimal Places
Status Bar Text
Validation Rule
Validation Text
Default Value
Typeface characteristics (such as Font Name, Font Size, Font Bold, Font Italic, and Font Underline)
Values of field properties that you override with ...
Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.