Sometimes, end users of your reports will ask you to number the lines in the printouts. But this request doesn't have to give you a headache.

However, if your first thought is to use an ID field based on an AutoNumber field, it probably won't do the trick because of gaps that can occur in the AutoNumber sequence.

Here's an easy way to number the records in your report. Open the report in Design view and add an unbound text box to the Detail section. Open the Properties dialog box for the new text box. On the Data tab, set the ControlSource property to =1 for the new text box.

At this point, you'll need to adjust the text box control's RunningSum property, which you'll also find on the Data tab. If you've grouped the report, set RunningSum to Over All. If you haven't grouped the report, set the property to Over Group.

Created Date: 12/18/2001  Last Reviewed: 12/18/2001  Rev. Date: 

This site was last updated 06/11/06