ACC97: Macro to VBA Uses Unexpected Syntax with Form References (162074)
The information in this article applies to:
This article was previously published under Q162074 Advanced: Requires expert coding, interoperability, and multiuser skills.
SYMPTOMS
When you use the "Convert Macros to Visual Basic" command to convert a
macro that contains a reference to a user-defined item on a form or report
to a Visual Basic for Applications event procedure, the code syntax that is
created from the conversion will use the . (dot) operator instead of the
! (exclamation point) operator for any implicit referencing in the
procedure.
CAUSE
The "Convert Macros to Visual Basic" command does not differentiate between
implicit and explicit referencing when a macro is converted to a Visual
Basic for Applications procedure.
RESOLUTION
In modules that are created from the "Convert macros to Visual Basic"
command, both operators are acceptable.
REFERENCES
For more information about implicit and explicit form referencing, search
the Help Index for "referencing, controls in expressions," and then "Use
the ! and .(dot) operators in expressions" or ask the Microsoft Access 97
Office Assistant.
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbprb kbProgramming KB162074 |
---|
|