Create a calculated control on a form or report

1. Open a form in Design view or a report in Design view.
   
   
2. Click the tool in the toolbox for the type of control you want to use as the calculated control.

   Note   A text box is the most common type of control to use to display a calculated value, but you can use any control that has a ControlSource property.

3. On the form or report, click where you want to place the control.
   
   
4. Do one of the following:
   • If the control is a text box, you can type the expression directly in the text box.

   

   • For any control, make sure the control is selected, click Properties on the toolbar to display the control's property sheet, and type the expression in the ControlSource property box. To use the Expression Builder to create the expression in a Microsoft Access database (.mdb), click the Build button next to the ControlSource property box.

Notes

• In a calculated control, precede each expression with the = operator.
  
  
• 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 .