Software

Add a Close Form command button to your Access form

If the Close button on a Microsoft Access form is disabled, you can add a button to the form that will allow users to exit the form when they are done. Find out how the command wizard makes it easy to add this button.

Once you disable the Close button on a Microsoft Access form, you might be perplexed as to how users can close the form when they are done. You can simply use the command wizard to add a button to the form that, when clicked, will allow users to exit the form.

First, you need to open the form in Design View, and make sure the Control Wizard button in the toolbox is selected. Then, follow these steps:

  1. Click the Command Button tool, and then click where you want the button to appear in your form.
  2. Select the Form Operations category and then click Close Form under Actions.
  3. Select the default text or type your own, and click Next.
  4. Enter a name for the command, such as CloseForm button, and then click Finish.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox