Results 1 to 3 of 3
  1. #1
    bvbowes is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2018
    Posts
    1

    VBA Code Formatting Software

    I have many Access programmers in my office and I'd like everyone's VBA to look the same. Does anyone use software out there that formats VBA for you? Toad has this with SQL and our SQL library looks great, so I figured someone has something that could work.

  2. #2
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    VBA indenter http://www.oaltd.co.uk/indenter/indentpage.asp is great, but doesn't work on later versions.
    It's been morphed into Rubberduck http://rubberduckvba.com/ which is very powerful but can be a bit buggy, and doesn't always seem as clean/organised as the original.

    It's shame you can't use the old Indenter on newer versions, it really was great.
    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 ↓↓

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    You could also try googling MZ Tools for VBA...I believe formatting of code is one of its many, many features.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. conditional strFilter formatting/code
    By lbaccess101 in forum Reports
    Replies: 6
    Last Post: 08-07-2017, 01:17 PM
  2. code to apply control formatting
    By tariq1 in forum Programming
    Replies: 3
    Last Post: 07-21-2012, 12:36 PM
  3. Replies: 1
    Last Post: 06-22-2012, 03:33 PM
  4. zip code formatting
    By techexpressinc in forum Queries
    Replies: 14
    Last Post: 09-21-2010, 06:03 AM
  5. Formatting E-mail Using Code
    By graviz in forum Programming
    Replies: 10
    Last Post: 12-10-2009, 10:10 AM

Tags for this Thread

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