Any plugin available to highlight conditional blocks in Access?

[Wrathchild]

Hi, I was wondering if anybody knows of a plugin or whatever to highlight start and end sections of conditions? For example, I'd like to select "If" and have the corresponding "End If" highlight. I'm working from within MSAccess. thanks!

 

[SkipVought]

Hi,

I've never found a need for color coding blocks of code. I use native VBA, with no add-ins. I have, however, modified the Tools > Options...

I use the TAB key to indent my code, so that the blocks are readily noticable and much more understandable, like this...

   With objNewMail
      For Each varRecip In astrRecip
         .Recipients.Add varRecip
      Next varRecip
      blnResolveSuccess = .Recipients.ResolveAll
      If Not IsMissing(astrAttachments) Then
        For Each varAttach In astrAttachments
           .Attachments.Add varAttach
        Next varAttach
      End If
      .Subject = strSubject
      .Body = strMessage
      If blnResolveSuccess Then
         .sEnd
      Else
         MsgBox "Unable to resolve all recipients. Please check " _
            & "the names."
         .display
      End If
   End With

Just my 2¢.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[Wrathchild]

thanks, I do that too, but sometimes with long code and many conditions it can get hard to read...was just curious...I found it very helpful in my java work

 

[PHV]

Have a look here

http://www.oaltd.co.uk/Indenter/Default.htm

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886