Learn all about formatting Access forms to make your Access database look more professional, consistent, and user friendly.
Video: Formatting Forms in Access 2010Watch the video (3:54).
Access offers many options that let you make your forms look exactly the way you want. While some of these options—like command buttons—are unique to forms, others may be familiar to you.
If you want to create a way for users of your form to quickly perform specific actions and tasks, consider adding command buttons. When you create a command button, you specify an action for it to carry out when clicked. By including commands for common tasks right in your form, you're making the form easier to use.
Access offers many different types of command buttons, but they can be divided into a few main categories:
- Record Navigation command buttons, which easily allow users to move among the records in your database
- Record Operation command buttons, which let users do things like save and print records
- Form Operation command buttons, which give users the ability to quickly open or close a form, print the current form, and complete other actions
- Report Operation command buttons, which offer users a quick way to do things like preview or mail a report from the current record
To add a command button to a form:
- In Form Layout view, select the Form Layout Tools Design tab and locate the Controls group.
- Select the Button command.
The Button command
- Your cursor will turn into a tiny crosshairs with a button icon . Place it in the spot where you want your command button to be, then click.
Placing the new command button
- The Command Button Wizard will appear. In the Categories pane, select the category of button you want to add. We want to find a way to move more quickly to specific records, so we'll choose the Record Navigation category.
- The list in the Actions pane will update to reflect your chosen category. Select the action you want the button to perform, then click Next. For our example, we'll choose Find Record.
Selecting the type of command button to create
- You can now decide whether you want your button to include text or a picture. A live preview of your button appears on the left.
- To include text, select the Text option, then type the desired word or phrase into the text box.
Adding text to the command button
- To include a picture, select the Picture option. You can decide to keep the default picture for that command button, or you can select another picture. Click Show All Pictures to choose from another command button icon or Browse... to choose a picture from your computer.
Using a picture in the command button
- When you are satisfied with the appearance of your command button, click Next.
- Type a name for the button. This name won't appear on the button, but knowing the name will help you quickly identify the button if you ever want to modify it with the Property Sheet. After typing the button name, click Finish.
Typing a name for the button
- Switch to Form view to test the new button. Our Find Record button opens the Find and Replace dialog box.
Testing the command button
Some users report that Access malfunctions while formatting forms. If you have a problem performing any of these tasks in Layout view, try switching to Design view.