DMW logo
contact@consultdmw.com

Attaching Labels to Objects on Microsoft® Access Forms and Reports

How to, in the design of forms and reports, attach and re-attach labels to text boxes, combo boxes, list boxes, etc.

Last updated on 2021-01-06 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. I recommend giving your label an approtiate name that starts with your usual prefix identifying a label object
  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, 2016, 2019 and Microsoft 365.

Access 2019 introduced 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.

This example is of the Property Sheet for a combo box named “cboFindCompany” to which the label named “lblCboFindComppany” is attached:

Access database form label name property

This is an example of where I have applied a convention for naming database objects, as explained in Conventions for Naming Objects in Microsoft Access Daabases.


Naming Labels

When you add a control such a text box to your form in its design view, Access furnishes that control with a label, as in this simple example:

Access database form design

If we switch the focus to the label itself …

Access database form design naming of labels

… we can examine the properties of the label to learn that Access has assigned the value “Label6” to the Name property of the new label:

Access database form label property sheet

A default name such as Label6 doesn’t make it easy to relate that label to other control objects on a form. That’s why I consider it best to name such an object so that its identity and function are obvious to me. So, the value I assign to the Name property is made up of an appropriate name with a prefix that identifies the type of control.

In the image of the form above, consider text box that is bound to the InvoiceID field. I reckon tebInvoiceID would be a good name for it; and lblInvoiceID for the label to the left of it.

The Leszynski naming convention is what’s guided me through using names in this fashion. See Convention for Naming Objects in Microsoft Access Databases for details.


Your Support for DMW TIPS

Please support this website by making a donation to help keep it free of advertising and to help towards cost of time spent adding new content.

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

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

Thanks, in anticipation.


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