Link to home
Start Free TrialLog in
Avatar of MitchellVII
MitchellVIIFlag for United States of America

asked on

Is there a way to request "Word Wrap" in the Access Visual Basic Editor?

I am using the VB Editor and am continually having to use line continuations so I can see all my code.  If there was a simple (word wrap) option, this would be avoidable.

Is there not and if not, why not?  Is there an add-on I can use to get it or a better VB Editor I can use with Access?
ASKER CERTIFIED SOLUTION
Avatar of tward
tward

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tward
tward

Probably a matter of it needs to know when the next line is a continuation, or another line of code.  
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Note, you will still NOT get a word wrap option, but MZTools allows you to Split / Combine Lines (add or remove the line continuation characters)
Avatar of MitchellVII

ASKER

Thanks Tubbs,

I'll look into the MZTools things.

You know, in Access 2007 you would think M$ would have spent more time improving things we actually use everyday like the VBA Editor instead of those idiotic Ribbons and the even more idiotic Navigator Pane.

For instance, in M$ Visual Studio, there IS a wordwrap option, but in Access VBA there ISN'T?  So they put it in the flagship product (must think it's a good idea) and leave it out of the Access product?  Also, how about having a VERY limited number of "undo's" available in the VBA Editor?  Is THAT somehow a benefit to anyone?

Who the heck is the retarded monkey making product development decisions over there?
MitchellVII said:
>>You know, in Access 2007 you would think M$ would have spent more time improving things
>>we actually use everyday like the VBA Editor instead of those idiotic Ribbons and the even
>>more idiotic Navigator Pane.

Mitchell, remember that VBA is basically an iteration of VB6.  Since VB6 is on the way out
right now in favor of VB.net, I think it's safe to say that MS will not be making any substantial
investments in the VBIDE interface.
Can I somehow use a different VBA Editor (that is more fully featured) that Access will go to as the default?
matthews,

That and the fact that M$ loves to ignore what needs fixing and break what works.  Office 2007 is a perfect example of this philosophy.  Take Word 2007.  That program is worse in almost every conceivable way than Word 2003 was.  And don't get me started about Outlook 2007 - they don't even use their own IE rendering engine for HTML!