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 of those reasons are.

• To display information from a field onto a page header/footer.
  • For example, I want to see the Responsible Attorney name from the page that I’m on in my Matters report.
• To use a number from a field for mathematical purposes.
  • For example, I needed to have a row count, but needed add a number to that. The part I couldn’t do in the expression was to add a number to it. It would have added that number every time, thereby throwing off the count of the row by the number added, every time. So, I referenced that field, in another field, and added the 2 that was needed.

Here’s how we can do this. First, it would be quite helpful, but necessary, to rename the field you want to reference. This is much like when we were creating the header/footer template from earlier in this document. Renaming text boxes within a table is done the same way. Right click on the text box with the arrow, not cursor, textbox properties, and name it right there.

To then reference this field someplace else we would have an expression like this:

=ReportItems!MyTextboxName.Value

Wherein, you replace the bold section with your textbox name.

#ProLaw #ProLawReports