Solved

Microsoft Access VBA ---  collapse code

Posted on 2012-03-15
3
1,283 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
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 …

943 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

4 Experts available now in Live!

Get 1:1 Help Now