Adding a Logo to Access 2007 Reports - dummies

By Brian Underdahl, Darlene Underdahl

If you want to add a nice touch of class to your Access 2007 reports, why not add your own logo? Most companies and organizations have logos they use to add an official-looking appearance to letterheads, business cards, and so on, so why not use your logo on your reports, too?

Using a logo on an Access report is pretty easy, but there are a few little ways that Access might try to trip you up. Here’s how to add a logo that you’ve stored in an image file:

1. Open your report in Design View.

2. Click in the Report Header section of the report.

Make sure that you click the report section where you want to add the image before continuing; otherwise, Access adds the image in whichever report section was last selected (probably the Detail section) and expands the height of the section to fit the image size.

3. In the Design section of the Ribbon, choose the Logo option.

4. Select the image file you want to use and click OK to close the dialog box and insert the picture.

5. Make certain that the image is selected and click the Properties button to display the Properties dialog box for the image.

6. On the Format tab, select Stretch from the drop-down Size Mode list box.

This option enables you to resize the image without cropping it. The default setting for this property, Clip, crops the image when you attempt to resize it. The Zoom setting is similar to Stretch, but it’s a little harder to control.

7. Use the resizing handles along the sides and corners of the image to resize it as necessary.

You may also have to resize the Report Header to eliminate any extra height that Access added when you inserted the picture, and you may need to move some other objects, such as the report title, to get the appearance you desire.

In most cases, the Report Header section is the appropriate place to add a logo because you use a logo for visual impact. Including a large logo on every page or alongside every record dilutes its impact. On the other hand, if you have a very small version of your logo, you could include that small version in the Page Header section.

Any image that you add to a report as a logo is an example of an unbound control because the image isn’t associated with the data in one of the database tables. Images that are stored in fields as either linked or embedded objects can also appear in a report by including a bound control in the Detail section of the report. There’s no special technique required to add these types of bound image controls to your reports, but the same Size Mode property considerations in Step 6 of the previous list also apply to bound image controls.