The design of rptBullets is shown in Figure 20-16. Notice the bullet character in the
txtCompanyName text box as well as in the Property Sheet for this text box.
658
More Advanced Access Techniques Part III
FIGURE 20-16
The bullet character is added to the ControlSource property of the txtCompanyName text box.
The bullet is added by exploiting a Windows feature. Position the text insertion character in the
RecordSource property for the CompanyName field and type in 0149 while holding down the
Alt key. Windows inserts the standard Windows bullet character, which you see in the Property
Sheet. Looking at Figure 20-16, you can see that the bullet character is inserted correctly into the
text box on the report. The expression you use in the ControlSource property is the following:
= ?????? ??? & [CompanyName]
where the bullet is inserted by the Alt+0149 trick.
You can produce the same effect by using the following expression in the text box:
= Chr(149) & ??? ??? & [CompanyName]
This expression concatenates the bullet character (returned by Chr(149)) with the data in the
CompanyName field.
Pages:
1278
1279
1280
1281
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293
1294
1295
1296
1297
1298
1299
1300
1301
1302