Code more than One line

[msofficebeginner]

If code exists more than single line how to continue the code to 2nd line

Thanks

 

[alvechurchdata]

Put an underscore at the end of the line:

  If Err = GI_RECORDLOCKED Or _
     Err = GI_TABLELOCKED Or _
     Err = GI_USERCONFLICT Then

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[msofficebeginner]

Hello
I have a sql string which exceds one line, it is coming to second line, hwto get this.

example:
strD = " SELECTE STATEMENT......................." _
strD = " FROM ..........." _
strD = " WHERE ............"

is it correct?

 

[TheAceMan1]

how are ya msofficebeginner . . .

In help, have a look at the [blue]Line Continuation Character[/blue].

See Ya! . . . . . .

 

[spizotfl]

StrD = "SELECT ... " & _
"FROM ... " & _
"WHERE ... " & _

or

StrD = "SELECT ..."
StrD = StrD & " FROM ... "
StrD = StrD & " WHERE ... "

 

[PHV]

And yet another way:
strD = " SELECTE STATEMENT......................." _
& " FROM ..........." _
& " WHERE ............"


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886