Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Access
Search
Search
 
Check for updates: (c) Microsoft
Microsoft Update
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Set column properties (ADP)
 

Note  The information in this topic applies only to a Microsoft Access project (.adp).

You can set or change the properties of a column.

ShowSet column properties in a database diagram

  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 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.

ShowSet column properties in Table Designer

  1. Click Tables Button image 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.

advertisement