Replace a global default value with a default value (ADP)
Note The information in this topic applies only to a Microsoft Access project (.adp).
- 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.
- If necessary, right-click the table and select Column Properties, Column Names, Keys, or Custom View from the shortcut menu.
- Assign a new default value to the column you want to change.
- A message prompts you to permanently unbind the existing default in order for the new default to be applied. Choose OK.