CREATING VBA OBJECT BASE NAMES

When creating Visual Basic object base names, remember that the base name must be descriptive even in the absence of its tag. For many programmers, the syntax Dim I As Integer for a loop variable is quite acceptable. Within LNC, however, the variable named I would become iintLoop. Single-character variable names—especially without tags—aren't allowed. Instead, create a list of short and standardized work variables to handle common daily needs. Table D.10 suggests the LNC approach to commonly used variables.

Table D.10. Standardized LNC Work Variables
Variable Description
blnRet Captures a true/false return value from a function call
cccDebug Creates a conditional compilation constant for turning conditional debugging ...

Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.