VBA editor

  • Thread starter Thread starter Jasper Recto
  • Start date Start date
J

Jasper Recto

If your writing a statement in the VBA editor and your statement is long,
how do you make it continue to the next line?

If I hit 'return', my statement turns red because it thinks it's a new
command.

Thanks,
Jasper
 
Use a space and then underscore
e.g.
If your writing a statement in the VBA editor _
and your statement is long
 
Dennis said:
Use a space and then underscore
e.g.
If your writing a statement in the VBA editor _
and your statement is long
Click to expand...

To add to this. This usually happens when creating a string to use in
a SQL command or recordset command. See
http://www.granite.ab.ca/access/email/formattedsamplecode.htm for much
sample code on how I do that stuff.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Back
Top