Make your Access reports more readable by numbering detail items

One simple way to improve your report design is to number each item. Mary Ann Richardson steps through an example that demonstrates this technique.

You can make a long report easier to reference by numbering the line items sequentially. For example, to number the example Employee Statistics Report shown in Figure A, follow these steps:

Figure A

  1. Open the report in Design View.
  2. Place a text box named txtRunningSum at the left side of the report's detail section.
  3. Click in the Control Source property and enter =1 (Figure B).

Figure B

  1. Click in the Visible property and select No.
  2. Click in the Running Sum property and select Over All.
  3. Add another text box next to txtRunningSum.
  4. Enter this code in the Control Source property: =[txtRunningSum]&"."
Figure C shows the numbered report.

Figure C

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.