Change which properties appear in a database diagram (ADP)

Microsoft Office Access 2003

  1. In the Database window, click Database Diagrams Button image 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 property column you want to hide. If necessary, right-click the table, and then click Column Properties or Custom View.
  3. Position the pointer along the right border of the column header for the column that you want to hide. The cursor changes from an arrow to a splitter pointer Splitter pointer.
  4. Drag the column border to the left until it meets the column’s left border.
  5. Release the mouse button.

ShowShow a property column that is hidden

  1. In the Database window, click Database Diagrams Button image 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 property column you want to show. If necessary, right-click the table, and then click Column Properties or Custom View.
  3. Position the pointer along the right border of the previous column’s header. The cursor changes from an arrow to a splitter pointer Splitter pointer.
  4. Double-click the splitter pointer. The hidden column resizes to fit the widest entry.

    Note   You can also set which column properties you want to display for database tables in a database diagram by using the Custom view command on the Table submenu of the View menu.