DMW logo
tel 01732 833085
tonbridge · kent · UK

Attaching and Re-attaching Labels to Control Objects on Access Forms and Reports

Last updated on 2019-04-15 by David Wallis.


Question

“David, Whilst working on the design of an Access database form I managed to delete the label attached to one of the text boxes. I know I can put a new label on the form, but it won’t be attached to the text box. Is there a way of doing this?”


Response

Yes there is. It works for restoring a label to any control object on your form (or on a report), not just to a text box:

  1. Create the new label that you want to attach
  2. Select the label
  3. Issue the Cut command
  4. Select the control to which you want to attach the label
  5. Issue the Paste command.

This technique should stick the label to the control and is applicable to Microsoft Access 97, 2000, 2002, 2003, 2007, 2010, 2013 and 2016.

Access 2019 has a new Label Name property that you can make use of instead of the cut-and-paste technique:

  1. Create the new label that you want to attach, and give it an appropriate name so that it’s easy to pick out from any list of controls
  2. Select the text box, list box or any other control to which you want this label associated
  3. From the Label Name property list, pick the label.

Your Support for dmw TIPS

If you’re going to make use of Tips in any of your professional or commercial work, then please consider making a payment in recognition of the time spent publishing this website.

To make a contribution by PayPal in GBP (£ sterling) —

To make a contribution by PayPal in USD ($ US) —

To say how much you want to pay and to receive
a tax invoice for a GBP (£ sterling) contribution —

Invoice

Thanks, in anticipation.

SSL Cerification


Disclaimer

DMW Consultancy Ltd does not accept any liability for loss or damage to data to which any techniques, methods or code included in this website are applied. Back up your data; test thoroughly before using on live data.

“It’s fun seeing my label on someone’s behind — I like that”

Calvin Klein