Show All

Copy formatting from one control to another

This procedure does not apply to data access pages.

1. Open a form or report in Design view.
2. Click the control that has the formatting characteristics that you want to copy.

   Note  You can copy characteristics only from a single control.

3. Click Format Painter on the Form Design or Report Design toolbar. If you know that you'll want to use the same formatting characteristics on several controls, double-click the button to lock it down.
4. Click the control that you want to paste the formatting characteristics to. You can click the same type of control, or you can select another type of control. For example, you can copy formatting characteristics from a text box to a list box.

   Microsoft Access copies any of the following properties:

   • BackColor
   • BackStyle
   • BorderColor
   • BorderStyle
   • BorderWidth
   • DisplayWhen
   • FontItalic
   • FontName
   • FontSize
   • FontUnderline
   • FontWeight
   • ForeColor
   • LabelAlign
   • LabelX
   • LabelY
   • LineSlant
   • SpecialEffect
   • TextAlign
   • Visible

Note  You can't copy properties to or from ActiveX controls.