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

• Microsoft Access versions 2.0, 7.0

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.

Additional query words:

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