Improve company productivity with a Business Account.Sign Up

x
?
Solved

notes with multiple lines in code...apostrophe workaround

Posted on 2012-03-23
4
Medium Priority
?
240 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 2000 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 59
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

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

585 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