SYMPTOMS

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

In the Module window, when you use the Object box to display an OLE control event procedure, the name of the custom control is listed in the Object box under "general" rather than under the name of the custom control.

CAUSE

The OLE control Name property has too many characters.

STATUS

This behavior no longer occurs in Microsoft Access for Windows 95 version 7.0.

RESOLUTION

Limit the Name property of custom controls to 20 or fewer characters.

NOTE: You can copy and paste the code that you created for the truncated custom control's event procedure from the "general" section to the new custom control.

MORE INFORMATION

When Microsoft Access creates event procedures, it combines the name of the control and the event procedure, separated by the underscore character. If the control name is longer than 20 characters, Microsoft Access truncates the control name portion of the Sub declaration to 20 characters.

The situation occurs only if you use the short-cut method (click the object, click the right mouse button, and then click Build Event) to open the Module window.

Microsoft Access initially creates the event procedure using the full name of the control. If the control name is longer than 20 characters, Microsoft Access truncates the control, creating a new event procedure. Microsoft Access places the original event procedure under "general" in the Object box. Any code entered in the event procedure is contained in the event procedure in the "general" section. The new, truncated event procedure is empty.

Steps to Reproduce Behavior

1. Create a new form and insert a custom control.
2. Set the custom control's Name property to "testtesttesttesttesttest" (without the quotation marks).
3. Click the custom control, click the right mouse button to display the shortcut menu, and then click Build Event.
4. Enter any valid Access Basic statement. Note that the custom control's event procedure is listed under "general" in the Object box.