Calling a Field by its Textbox Name

It may be necessary to use information found in one textbox in another textbox. This is not limited to freestanding textboxes — this could be textboxes within tables. Some reasons you might need this:

• To display information from a field onto a page header/footer. For example, seeing the Responsible Attorney name from the page you're on in a Matters report.
• To use a number from a field for mathematical purposes. For example, you need a row count but also need to add a number to it — referencing the field allows you to add just once.

How to Do It

First, rename the textbox you want to reference. Right-click on the textbox (with the arrow, not cursor), select Textbox properties, and name it there.

To reference this field somewhere else, use an expression like this:

=ReportItems!MyTextboxName.Value

Replace MyTextboxName with your textbox's name.