ms-access calculated controls

Question

can someone give me an example of what a calculated control is in ms-access?

Answer 1

you mean this?

Answer 2

Say you add a text box to a form, normally it binds back to a specific field in a table, and its contents reflect the contents of that field. A calculated control does not refer to a specific field in a table, rather it displays the calculation done on one or multiple fields in the database. Sometimes, it may not use any fields.

Example of control source value from a calculated control

=[YearlySalary]/52

Presuming that there is a field called yearly salary in the table the form is based on.

A control that simply displays this field would have the following in the control source

YearlySalary

Note the control source for a calculated control starts with an =

Answer 3

Setting the Control Source of a control, generally a textbox, to a calculation creates a calculated control:

=1 * 2
=[TheDate] - 1
=[Stock] * [UnitPrice]
=DlookUp("TheField","TheTable","FieldX=1")