For reports based on parameter queries, it is helpful if the parameters used to generate the report are displayed in the report title. You just need to create a text box next to the report title and enter =Reports![reportname]!parametername] as the Text box’s control source.
For example, suppose you have created a report called Hours Worked for Week Ending based on the Parameter query shown in Figure A.
To add to your title the date that’s input into the parameter query box, follow these steps:
- Add a text box to the end of the report title.
- Right-click the text box and select Properties.
- Click in the Control Source property and enter =Reports![Hours Worked for Week Ending]![Enter Week Ending Date] (Figure B).
- Format the text box to match the rest of the Report title (Figure C).
When the report is run, Access displays the date entered for the parameter in the text box following the report title (Figure D) . You can also place the text box displaying the report’s parameters in the report header.
Miss an Access tip?
Check out the Microsoft Access archive and catch up on other Access tips.
Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.