Share via


How to: Resize Report Controls

You can resize any report control except Label controls. You can resize each report control manually or change their dimensions to match the size of a selected other report control.

To resize picture files and General fields in reports, first set them to scale. For more information, see Resizing Picture/OLE Bound Controls futher down in this topic.

You can also specify that the report control expands and contracts, or stretches, depending on its contents. For more information, see How to: Set Stretching Report Controls.

Note

The size of a Label control depends on the length, font style, and font size of the contents in the control.

To resize a report control manually

  1. Open the report or label in the appropriate designer.

  2. In the designer, select the control.

    Selection handles appear on the edges of the control.

  3. Drag a selection handle to increase or decrease the size of the control.

    Tip

    For more precise sizing, you can press and hold the SHIFT key while you press the arrow keys to change the size of a selected control.

To specify a size for a report control

  1. Open the report or label in the appropriate designer.

  2. In the designer, double-click the report control you want to resize.

    The properties dialog box for the report control opens.

    Note

    If the _REPORTBUILDER system variable is not set to the default Report Builder or is set to a third-party builder, the report control dialog box displays or a different dialog box might display. For more information, see _REPORTBUILDER System Variable.

  3. In the report control properties dialog box, click the General tab if it is not selected.

  4. In the Height and Width boxes in the Size and position in layout area, type or select the height and width you want.

  5. When you are finished, click OK.

For more information, see General Tab, Report Control Properties Dialog Box (Report Builder).

To match the size of another report control

  1. Open the report or label in the appropriate designer.

  2. In the designer, select the report controls you want using the multiple selection method.

    Note

    If you group report controls using the Group command on the Format menu, only the To Grid sizing option is available. For more information, see How to: Group Report Controls.

  3. On the Format menu, select Size and choose the appropriate option from the submenu:

    • To Grid

    • To Tallest

    • To Shortest

    • To Widest

    • To Narrowest

    The selected controls resize according to the option you selected.

For example, selecting To Tallest as the sizing option resizes all selected controls to the tallest control.

Resizing Picture/OLE Bound Controls

Image files and General fields added to the report page layout retain their original size by default. When added to the layout, an image file or the contents of the General field might not fit the frame that contains the image or the General field. If the image or General field is larger than the frame, only a portion of the image or General field contents appear visible in the upper left corner of the frame. The remaining lower right portion extends beyond the frame and view.

However, you can resize image files and adjust the contents of General fields to fit their frames.

To resize a picture file or adjust a General field to fit its frame

  1. Open the report or label in the appropriate designer.

  2. In the designer, double-click the Picture/OLE Bound control you want to resize, or right-click on it and select Properties from the context menu.

    The Picture/OLE Bound Properties dialog box opens.

    Note

    If the _REPORTBUILDER system variable is not set to the default Report Builder or is set to a third-party builder, the Report Picture dialog box displays or a different dialog box might display. For more information, see _REPORTBUILDER System Variable and Report Picture Dialog Box.

  3. In the Picture/OLE Bound Properties dialog box, click the General tab if it is not selected.

  4. On the General tab, choose one of the following options from the If source and frame are different sizes drop-down list:

    • To fill the frame with the image or contents of the General field but retain its relative proportions, click Scale contents, retain shape.

    • To fill the frame with the image or contents of the General field and stretch it vertically or horizontally as needed, click Scale contents, fill the frame.

      Note

      Choosing Scale contents, fill the frame may distort the proportions of the image or General field.

  5. When you are finished, click OK.

For more information, see General Tab, Report Control Properties Dialog Box (Report Builder).

See Also

Other Resources

Configuring Report Controls
Managing Report Controls
Working with Report Controls