Copying formatting in Access

Once a control is formatted, you do not have to repeat that formatting for other controls that you want formatted the same way. Instead you can use the Format Painter button to copy the formatting:

1. Select and format the control.
2. Click the Format Painter button
   

   

   
   
   once if you are copying the format to one control (double-click if you are copying to multiple controls).
   
3. Click the control(s) to which you want to copy the format.

If you double-clicked the Format Painter, click it again now to turn it off. If you single clicked, it turns off automatically.