Microsoft Access 2010 Bible

Chapter 9: Presenting Data with Access Reports 353 Entering an expression in a text control Expressions enable you to create a v ...

Part I: Access Building Blocks 354 Tip You can always check your result by clicking the Print Preview button on the toolbar and ...

Chapter 9: Presenting Data with Access Reports 355 FIGURE 9.31 A print preview of the report so far Controls in page header Cont ...

Part I: Access Building Blocks 356 To cut an attached label control (in this case, the label attached to the Description text bo ...

Chapter 9: Presenting Data with Access Reports 357 To move only one of the controls in a compound control, drag the desired cont ...

Part I: Access Building Blocks 358 FIGURE 9.32 Rearranging the controls on the report Modifying the appearance of multiple contr ...

Chapter 9: Presenting Data with Access Reports 359 Note This may seem to be an enormous number of steps because the procedures w ...

Part I: Access Building Blocks 360 You might also consider changing the Border Style property to Transparent. When set to Transp ...

Chapter 9: Presenting Data with Access Reports 361 TABLE 9.1 Text Control Values for Can Grow and Can Shrink Property Value Desc ...

Part I: Access Building Blocks 362 Follow these steps to create a Category group header: Click the Sort & Group button in t ...

Chapter 9: Presenting Data with Access Reports 363 Currency, or Number data types provide three options: l Each Value: Includes ...

Part I: Access Building Blocks 364 FIGURE 9.34 The Group, Sort, and Total area completed With A on Top button Adds a group Adds ...

Chapter 9: Presenting Data with Access Reports 365 Sizing a section Now that you’ve created the group header, you might want to ...

Part I: Access Building Blocks 366 Figure 9.35 shows this property window and the completed report design. The Property Sheet is ...

Chapter 9: Presenting Data with Access Reports 367 The four Force New Page property settings are l None: No forced page break (t ...

Part I: Access Building Blocks 368 In Figure 9.36, you can see opportunities for improvements. FIGURE 9.36 The report is pretty ...

Chapter 9: Presenting Data with Access Reports 369 The next step is to add a nice thick line separating the Page Header section ...

Part I: Access Building Blocks 370 You may find that Access complains about a circular reference on the Category text box after ...

Chapter 9: Presenting Data with Access Reports 371 Numeric data controls are right-aligned by default. Because they’re next to e ...

Part I: Access Building Blocks 372 The Title button in the Header/Footer group adds the report’s name as the report header’s tit ...