Solved

Microsoft Access VBA ---  collapse code

Posted on 2012-03-15
3
1,269 Views
Last Modified: 2012-03-15
Hi.

I am using Microsoft Access VBA.

If I were to use Visual Basic.net,  then the following code (see below) would enable me to collapse / hide some coding that I am not presently working on.  Is there a way to do this in Microsoft Access VBA.

-------------------------- code --------------------------------

#Region "Region Name"
        ... code ...
 #End Region
0
Comment
Question by:peispud
3 Comments
 
LVL 119

Assisted Solution

by:Rey Obrero
Rey Obrero earned 250 total points
ID: 37724334
sorry, but the answer is NO.
0
 
LVL 9

Accepted Solution

by:
armchair_scouse earned 250 total points
ID: 37724344
No, not as far as I know.

The closest thing to showing only certain bits of code is to change your module view to show one procedure at a time, but that would require you to make a separate procedure for each section of code you'd want to put in regions.  Not collapsable and hardly the same.
0
 

Author Closing Comment

by:peispud
ID: 37724646
Thank you.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now