How to split Lines of VB Code too Long?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jrtmax - 07 Jul 2005 19:00 GMT

I am having a problem with some lines of VB Code which are too long for one
line position to hold. Is there some way to wrap the code down to the next
line without disturbing the logic of the code?

For example:

lsSQL = "INSERT INTO 5_Deficiency_Item ([ITEM_ID],[Eval_Framework_Chart])
VALUES('" & Me![InvisibleID1] & "',2)"

when I split the code like I did above, it shows as an error.

Thanks!

Reply to this Message

Madhuri - 07 Jul 2005 19:11 GMT

lsSQL = "INSERT INTO 5_Deficiency_Item ([ITEM_ID], " & _
"[Eval_Framework_Chart]) " & _
" VALUES('" & Me![InvisibleID1] & "',2)"

Madhuri

> I am having a problem with some lines of VB Code which are too long for one
> line position to hold. Is there some way to wrap the code down to the next
[quoted text clipped - 8 lines]
>
> Thanks!

Reply to this Message

jrtmax - 07 Jul 2005 19:50 GMT

Thank you Madhuri!!

> lsSQL = "INSERT INTO 5_Deficiency_Item ([ITEM_ID], " & _
> "[Eval_Framework_Chart]) " & _
[quoted text clipped - 14 lines]
> >
> > Thanks!

Reply to this Message

Alejandro - 12 Oct 2007 00:28 GMT

Hello Madhuri,

Does this trick only work after commas or parentheses? I tried it after
after the word "Or" in a conditional statement, and also while trying to
split the text of a message box to the next line, and it didn't work.

Thanks!

alepag

> lsSQL = "INSERT INTO 5_Deficiency_Item ([ITEM_ID], " & _
> "[Eval_Framework_Chart]) " & _
[quoted text clipped - 14 lines]
> >
> > Thanks!

Reply to this Message