O'Reilly logo

Access 2002 Programming by Example by Bob Villareal

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

Setting Up Spreadsheet-like Calculations in Report Controls

There are different ways to type expressions in report controls. You can right-click a control to access its Control Source property in the Property sheet, or you can click directly on the text box and start typing. You might be wondering, “Why not just type the formula in the box directly every time?” This method would work, except for the fact that you might need to right-click the controls anyway to check the other properties. What’s more, right-clicking the control offers options for better views of your expressions.

There are two ways to refer to controls in a report. You can refer to them by their control name or by their control source, which is most commonly the field name. ...

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