comment out multiple lines of code

[kidrobot]

just a quick question. How do you comment out mult lines of code? In c++ it's */ then /* (something like that lol) ... but how do I do this in VBA.

 

[rainman89]

using ' too much for ya!?

 

[Dennisk]

Access does not have that capability however
In access 2000 and above there is an edit toolbar and if you select more than one line of code the toolbar will allow you to comment/uncomment the whole block.

 

[kidrobot]

using ' too much for ya!?

it is when theres 100 lines of code =)

thanks denn that worked great!!

 

[RoyVidar]

There's also Conditional Compilation

#if 1=2 then

100 lines of code
debug this, and there should be no error

#end if

 

[Sasha Froyland]

just a quick question. How do you comment out mult lines of code? In c++ it's */ then /* (something like that lol) ... but how do I do this in VBA.

On 11/13/2022, in Microsoft Access Professional 2019, to comment out multiple code lines, customize toolbar and add from the Edit Category: 'Comment Block' and 'UnComment Block'.

 

[jdraw]

Hmmm. The previous post was 15 years ago??

 

[Cotswold]

I used this on my Access for a while now, I use it all the time. It will Rem out code that is blocked/selected and also Un-Rem, clear blocks of code.
Can't just recall how I set it but it must be easy. I'll look on that machine tomorrow and post the solution.

 

[Isaac]

Would love it if the VBA IDE implemented regions

 

[Gasman]

I used this on my Access for a while now, I use it all the time. It will Rem out code that is blocked/selected and also Un-Rem, clear blocks of code.
Can't just recall how I set it but it must be easy. I'll look on that machine tomorrow and post the solution.

As per post #6 ?

 

[MarkK]

There are Comment and Uncomment Block toolbar buttons...

Drag and drop them onto your custom Debug toolbar in the IDE.
hth