ACC: Procedure Name Ctl* Doesn't Match Control Name

ID: Q156198

The information in this article applies to:

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

When you create a control on a form that starts with a numeric character, and you then add an event procedure to that control, Microsoft Access will attach the characters "Ctl" (without the quotations marks) to the name of the procedure.

CAUSE

Microsoft Access does not allow a procedure name to begin with a numeric character; therefore, it automatically changes the procedure name to something that is valid.

RESOLUTION

Use the guidelines for naming Visual Basic procedures (or Access Basic procedures in Microsoft Access version 2.0) when you create controls that may be used in event procedures.

MORE INFORMATION

Microsoft Access has a different naming convention for Visual Basic (or Access Basic) procedures than it has for controls on forms. Procedure names must begin with a letter. Control names can start with a number and still be valid. However, if a control name starts with a number, and you add an event procedure to that control, Microsoft Access will attach the characters "Ctl" (without the quotations marks) to the name of the procedure.

Steps to Reproduce Behavior

1. Create a form not based on any table or query.

2. Set the Name property of the control to 1Name.

3. Create an event procedure for the control. Note that Microsoft Access

   changes the name to Ctl1Name.

Keywords          : kbusage FmsEvnt FmrOthr 
Version           : 2.0 7.0
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbprb

Last Reviewed: June 9, 1997