Set column properties (ADP)

1. In the Database window, click Database Diagrams under Objects, click the database diagram you want to open, and then click Design on the Database window toolbar.
2. In your database diagram, select the table whose column properties you want to define.
3. Right-click the table and choose Properties from the shortcut menu.
4. Select the Columns tab.
5. For each property you want to change, modify the value or setting.
6. Close the Properties dialog box.

The new setting takes effect in the database diagram as soon as you press the TAB key or click outside the cell in the Properties dialog box. The new setting is saved in the database when you save the table or your database diagram.

Note   If a column property is visible on the database diagram, you can edit that property value directly— without opening the property page.

1. Click Tables under Objects, click the table you want to open, and then click Design on the Database window toolbar.
2. To set a property, click in the grid cell for that property of the database column you want to modify, then enter the value.
   -or-
   Select the grid row describing the database column you want to modify, then modify the property in the tab appearing below the grid.

The new setting takes effect in the database diagram as soon as you press the TAB key or click outside the edited grid cell or control. The new setting is saved in the database when you save the table or your database diagram.