Add line numbers to the report

Keyboard Shortcuts

Running line numbers on the side of a report can be beneficial and make it easier to refer to specific line items during meetings or conference calls. In this movie, Adam demonstrates how to add an unbound textbox and use it to calculate a running line number for each record in the detail section of the profit summary report.

- [Voiceover] Sometimes adding a running line number…to the side of a report might be beneficial…and make it easier to refer to specific…line items during meetings or conference calls.…Using an unbound text box, we can add this type…of enhancement to our reports quickly and easily.…Let's go down and find the profit summary report…that we've been working on.…Right-click on it, and go into design view.…Then on the design tab of the ribbon,…we'll find the text box control…and click on it once to select it.…I'll come down here into the details section…and I'm gonna click once to add in a new unbound text box.…Let's start by getting rid of the label here,…I'll click on it and just delete it.…

Then we'll click back onto the text box…and open up the property sheet.…On the data tab, we'll find the property here…for the control source, and this where we're…gonna type in what we wanna see in this box.…In this case, we wanna create a running line number…that'll increase for every…new record in the details section.…I'm gonna type in the super secret…

Resume Transcript Auto-Scroll

Author

Released

7/6/2016

Learn how to use Access forms and reports to control and organize the display of your data, as well as gather parameters for queries. Access expert Adam Wilbert starts with the basics of form design and leveraging controls such as buttons, links, and macros. He combines these ideas in a chapter that shows how to build an application-like framework for getting around an Access 2016 database.

Then the course dives into reports: creating efficient and readable layouts, grouping data into categories, tying reports to queries, and using conditional formatting rules to highlight key takeaways from the data. Finally, Adam demonstrates how to link forms and reports and print your results, and introduces unique ways to save time filling out paperwork and generating form letters.