Microsoft Access 2010 Bible

Part I: Access Building Blocks

360

You might also consider changing the Border Style property to Transparent. When set to

Transparent, no boxes are drawn around the picture and the picture blends into the report’s

surface.

These steps complete the changes to your report so far. A print preview of the first few records

appears in Figure 9.33. If you look at the pictures, notice how the picture is properly displayed

and the product’s Features text box now appears across the bottom of each Detail section.

FIGURE 9.33

The report displayed in Print Preview

Growing and shrinking text-box controls

When you print or print-preview controls that can have variable text lengths, Access provides

options for enabling a control to grow or shrink vertically, depending on the exact contents of a

record. The Can Grow and Can Shrink properties determine whether a text control resizes its

vertical dimension to accommodate the amount of text contained in its bound field. Although

these properties are usable for any text control, they’re especially helpful for text-box controls.

Table 9.1 explains the acceptable values for these two properties.