Make a command button the Cancel button

Microsoft Office Access 2003

  • Open a form in Design view.
  • Click the command button, and then click Properties Button image on the Form Design toolbar to open the command button's property sheet.
  • In the Cancel property box, click Yes.
  • Note  To have a Cancel button cancel all the actions that have taken place in a form or dialog box, you need to write a macro or event procedure and attach it to the OnClick property of the button.

    ShowTip

    For a form that allows irreversible operations, such as deletions, it's a good idea to make the Cancel button the default command button. To do this, set both the Cancel property and the Default property to Yes.