DBWebApplications 





Access Data Manipulation  «Prev 

Add Calculated Control in Access

You can use calculated controls in Access databases to display the results of a calculation. For example, if you have a report that displays the number of items sold and the price of each unit, you can add a calculated text box that multiplies those two fields to display the total price. The Control Source property of the calculated text box contains an expression that multiplies two fields (the number of items times the unit price) to obtain the result.
This procedure helps you create a calculated control without using a control wizard.
  1. Right-click the form or report in the Navigation Pane, and then click Design View Button image.
  2. On the Design tab, in the Controls group, click the tool for the type of control you want to create.
    Calc Control
    For a list of control types that can be used as calculated controls, see the section Learn which types of controls can be used as calculated controls.
  3. Position the pointer where you want the control to be placed on the form or report, and then click on the form or report to insert the control.
  4. If a control wizard starts, click Cancel to close it.
  5. Select the control, press F4 to display the property sheet, and then type an expression in the Control Source property box. To use the Expression Builder to create the expression, click Builder button next to the Control Source property box.
  6. Switch to Form view or Report view and verify that the calculated control works as you expect.


The tabular form is actually a subform to a form that shows project data.
The tabular form is actually a subform to a form that shows project data.

Once the form is in design view, I need to add a new text box by using the Text Box button in the toolbox
Once the form is in design view, I need to add a new text box by using the Text Box button in the toolbox

Add a calculated control
Add a calculated control


I am ready to put the expression in the text box
I am ready to put the expression in the text box

The text box does not need to be large enough to display the whole expression
The text box does not need to be large enough to display the whole expression

The result is show in the form view.
The result is show in the form view.