smk23 said:
Real quick question:
Is there a way in Access to comment out blocks of code rather than the '
on
each individual row?
Thanks
--
There is no "comment" a block feature that many programming languages have.
So, the only way is to use a ' at the start of each line.
(there certainly is a button in the VBA editor that when clicked it will
place ' on a block at code in one click, but this is certainly a different
feature then a start/end means to comment out code...).
However, you can actually use complier directives, and do the following:
#If True = False Then
#End If
Note the use of #. The above expression means that any code included
between the #if True = False then, and the #End If will be skipped during
compile. This means also that when you compile the code down to a mde..the
above will not be included in the object file, and thus will be smaller in
size then if you used:
If True = False Then
end if
The other advantage of the "#if" compared to "if" is that this really does
behave like a commented out block of code since you can have compile errors
in that code block..but since the block is ignored by the compiler, it
essentially is the same concept of commenting out a block of code that many
IDE's have.
Normally, conditional compiling is used for version dependent features. (for
example, access97 does not have a split command..but a2000 does). So, you
could setup a constant for your version number..and have different code run
depending on what platform your target audience is going to be.
