Solved

notes with multiple lines in code...apostrophe workaround

Posted on 2012-03-23
4
229 Views
Last Modified: 2012-03-23
at present I add an apostrophe at the beginning of each line in my code when making notes. Sometimes the notes are lengthy and it's a pain to add them each time.

Is there an easier way to do this?
0
Comment
Question by:Shawn
  • 2
4 Comments
 
LVL 29

Expert Comment

by:Paul Jackson
ID: 37758167
Unfortunately not, vba does not support a multiline comment character.
0
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 500 total points
ID: 37758186
However you could write out the comment across multiple lines and then select all the lines and use the comment button on the edit icon bar with code builder to add the ' to the lines all at once.
0
 
LVL 57
ID: 37758198
If you don't add a quote, it's going to try and syntax check it (unless you turn it off, which is not good for the code you do write), and that's really annoying.  Much more so then have to type a single character IMHO.

Jim.
0
 
LVL 1

Author Closing Comment

by:Shawn
ID: 37758212
exactly what I was looking for but couldn't find it. thank you
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

786 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