Rusty Hammond
rusty.hammond at cpiqpc.com
Wed Jan 27 11:17:57 CST 2010
I agree, this should be in the IDE. The smart indenter is a pretty handy tool that Jim and Max suggested to help clean up code too. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Wednesday, January 27, 2010 9:46 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] IDE for VB/VBA This is good! After I copied VBA code into the window, I needed to set the language to VB - then I could collapse sections of code. And obviously, VBA should already have this feature! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kenneth Ismert Sent: Wednesday, January 27, 2010 9:21 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] IDE for VB/VBA Rusty Hammond > Does anyone use or know of any add-ins for vb/vba that would highlight > or somehow mark the beginning and end of an if/then statement? > The latest Notepad++ has a VB mode with structure folding. You can collapse the If, and tag the end. Also, you can right-click the If, select 'Using 1st Style', and highlight all If and End If blocks. Probably good enough for your purpose, and free. -Ken -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ********************************************************************** WARNING: All e-mail sent to and from this address will be received, scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc. corporate e-mail system and is subject to archival, monitoring or review by, and/or disclosure to, someone other than the recipient. **********************************************************************