ACC97: Label Shows ControlTip Text of Associated Text Box

• Microsoft Access 97

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

When a text box and a label are associated on a form (as they are by default when you add a text box) and you enter different text for the ControlTipText property of each control, both the text box and the associated label display the ControlTipText value of the text box.

RESOLUTION

If you want to display different control tips for a text box and its associated label, you must first "de-associate" them.

NOTE: The AutoLabel property of the default text box is responsible for specifying whether labels should be attached to new text boxes. For more information about the AutoLabel property and how to set it, search the Help Index for information on how to "Specify whether labels are automatically attached to new controls," or ask the Microsoft Access 97 Office Assistant.

To "de-associate" a text box and a label, follow these steps:

1. In Microsoft Access 97, open your form in Design view.

2. Click the label associated with a text box. Ensure that you select only the label (surrounded by handles) rather than both the label and the text box.

3. On the Edit menu, click Cut. If both the label and text box disappear, on the Edit menu, click Undo Cut and repeat step 2.

4. On the Edit menu, click Paste.

5. Drag the label to its original position.

MORE INFORMATION

Steps to Reproduce Behavior

1. In Microsoft Access 97, open the sample database Northwind.mdb.

2. Open the Customers form in Design view.

3. Right-click the label portion of the Company Name text box control (CompanyNameLabel) to bring up the shortcut menu, and then click Properties.

4. In the CompanyNameLabel properties box, click the Other tab.

5. Enter the following text in the ControlTipText property, and then close the properties box:

   label

6. Right-click the CompanyName text box control to bring up the shortcut menu, and then click Properties.

7. In the CompanyName properties box, click the Other tab.

8. Enter the following in the ControlTipText property, and then close the properties box:

   text box

9. Save the form. On the View menu, click Form View.

10. Note that the control tips for both the label and the text box say "text box" (without the quotation marks).

REFERENCES

For more information about control tips, search the Help Index for "ControlTipText Property," or ask the Office Assistant.