Replace a global default value with a default value (ADP)

Microsoft Office Access 2003

Replace a global default value with a default value (ADP)

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

  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. If necessary, right-click the table and select Column Properties, Column Names, Keys, or Custom View from the shortcut menu.
  3. Assign a new default value to the column you want to change.
  4. A message prompts you to permanently unbind the existing default in order for the new default to be applied. Choose OK.