Results 1 to 5 of 5
  1. #1
    ssanfu is offline Master of Nothing
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664

    Smart Indenters?????

    These are the VBA code indenters I have found:

    1)
    Smart Indenter v3.5 by Stephen Bullen - Office Automation Ltd.
    I love this free add in.... however I haven't been able to use it since being forced to convert to O365.
    Available free for Office 2000/2002/2003, Visual Basic 6 and Excel 97


    2)
    Rubberduck by Mathieu Guindon - Rubberduck Project
    I have tried Rubberduck, but did not/have not spent much time investigating it yet. It is FREE (so far) and has a lot to offer.
    Works in VBA6, VBA7.x (x86/x64), and yes, in VB6 too!



    And recently I found an indenter that works with A365!!

    3)
    AutoMacro by AutoMacro
    The VBA Code Indenter part is FREE.... and works with A365!!!
    AutoMacro's code indenter works in 32-bit Office and 64-bit.

    The other options requires buying the app. It seems a little steep for me , but did I mention it works in A365??


    Hope someone finds one of these helpful......

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Steve,

    I'm using Smart Indenter on O365. Also there is an Indenter in MZTools.

  3. #3
    ssanfu is offline Master of Nothing
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    orange, I tried 4 times to install it - never could. So I gave up and eventually found the AotuMacro indenter. Any tips?

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Steve,

    I've been using O365 for about 3 or 4 years. I don't recall anything special re Smart Indenter install. I do have 32 bit Access and have used Smart Indenter for years (probably with A97,A2003, A2010,O365-Version 2103.Build 13901.20400 ClicktoRun.).

    Click image for larger version. 

Name:	SI_Addin.PNG 
Views:	26 
Size:	57.8 KB 
ID:	45052
    Click image for larger version. 

Name:	SI_locatedInTheEditArea.PNG 
Views:	24 
Size:	85.4 KB 
ID:	45053

  5. #5
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    @Orange - 32 Bit - that's the rub, it doesn't work in 64 bit O365 from what I remember.

    I use MZ-Tools, which does work with 64 Bit, but the indenter isn't quire as good as Smart Indenter (IMHO - it doesn't align the declarations which I really like.)

    Steve - I'll have a look at Auto Macro though, see what the differences are.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Smart Database
    By jwallace in forum Database Design
    Replies: 2
    Last Post: 12-19-2015, 08:11 AM
  2. is this smart form possible?
    By ariansman in forum Access
    Replies: 3
    Last Post: 11-10-2014, 02:48 PM
  3. Remove all Smart Tags
    By wgroenewald in forum Access
    Replies: 3
    Last Post: 01-18-2012, 01:12 AM
  4. Smart Card error
    By Ashe in forum Forms
    Replies: 2
    Last Post: 10-17-2011, 03:22 PM
  5. Need a 'smart' field
    By doci4a in forum Programming
    Replies: 5
    Last Post: 03-04-2011, 09:43 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums