From the course: Access 2016: Forms and Reports
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Add line numbers to the report
From the course: Access 2016: Forms and Reports
Add line numbers to the 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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.