Reduce repetitive formatting for Access objects

Two timesaving tricks

This gallery is also available as an article and a PDF download.

Objects come with a set of built-in properties that determine how they look and behave. As you create new forms, reports, and controls, you can adjust an object's default properties as required. But often, you'll find that objects require the same changes. For instance, you may want to use a font other than the default throughout your database. Changing the font for every new control on every form and report is inefficient. There are two ways to reduce your work when the default formats Access offers aren't adequate:

  • Change control defaults for the current form or report.
  • Use a custom form or report as a template.

By Susan Harkins

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.