Copy formatting characteristics from one text box or other control to another in a form or report

1. Open a form in Design view or a 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 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:

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