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	FontItalic	LabelX
   BackStyle	FontSize	LineSlant
   BorderColor	FontUnderline	SpecialEffect
   BorderStyle	FontWeight	TextAlign
   BorderWidth	ForeColor	Visible
   DisplayWhen	LabelAlign
   FontName	LabelY

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