Microsoft Access 2010 Bible

Chapter 20: Advanced Access Report Techniques

723

FIGURE 20.17

The Running Sum column provides a ranking for each customer in order of purchases during January.

Adding bullet characters

You can add bullet characters to a list instead of numbers, if you want. Instead of using a separate

field for containing the bullet, however, you can simply concatenate the bullet character to the

control’s RecordSource property — a much easier solution. Access will “glue” the bullet charac-

ter to the data as it’s displayed on the report, eliminating alignment problems that might occur

with a separate unbound text box.

The design of rptBullets is shown in Figure 20.18. Notice the bullet character in the txtCom-

panyName text box as well as in the Property Sheet for this text box.

FIGURE 20.18

The bullet character is added to the ControlSource property of the txtCompanyName text box.