Calculate a total for one record in a form

1. Open the form in Design view.
   
   
2. Click the Text Box tool in the toolbox.
   
   
3. In the form's detail section, click where you want to place the text box.
   
   
4. Do one of the following:
   • Place the insertion point in the text box and type an expression that calculates a total. To see examples of expressions you can use to compute values for one record, click .
     
     
   • Make sure the text box is selected, click Properties on the toolbar to open its property sheet, and type the expression in the ControlSource property box. In a Microsoft Access database (.mdb), to use the Expression Builder to create the expression, click the Build button next to the ControlSource property box.

Notes

• If you need more room to type an expression in the ControlSource property box, press SHIFT+F2 to open the Zoom box.
  
  
• For more information about creating expressions in a Microsoft Access database (.mdb), click .
  
  
• For more information about creating expressions in a Microsoft Access project (.adp), click .
  
  
• If a form is based on a query, you may want to put the expression in the query instead of in a calculated control. For information on creating a calculated field in a query in a Microsoft Access database (.mdb), click . For information on creating a calculated field in a query in a Microsoft Access project (.adp), click .