O'Reilly logo

Ten Minute Guide to Access 97 by Faithe Wempen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Adding a Calculated Text Box

The most common thing that text boxes hold is references to fields, as you have seen in this lesson. However, text boxes have another purpose; they can also hold calculations based on values in different fields.

Creating a calculated text box is a bit complicated; first you have to create an unbound text box (that is, one that's not associated with any particular field). Then you have to enter the calculation into the text box. Follow these steps:

  1. Click the Text Box tool in the toolbox, and click-and-drag on the report to create a text box.

  2. Change the label to reflect what's going to go into that box. For instance, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required