How do I continue the code on the next line ? 1

[Rmcta]

If I am writing code, example:
DoCmd.OpenReport stDocName, acViewPreview, , "Country='" & strVal & "' AND ([FromDate] etc...
and wish to use more than 1 line for clarity, how do I end the line to be able to continue on the next?

 

[nat1967]

HI,

Just add an underscore "_" and continue.

example:

DoCmd.SendObject , , , strRecipient, _
, , "Message Subject", , True

HTH Have A Great Day!!!,

Nathan
Senior Test Lead

 

[Rmcta]

Nathan,
I tried that but my code becomes red as soon as I do that??

Here is the code:

DoCmd.OpenReport stDocName, acViewPreview, , "Country='" & strVal & "' AND _
([FromDate] BETWEEN (#" & dteValFrom & "#) AND (#" & dteValTo & "#) OR _
ToDate BETWEEN (#" & dteValFrom & "#) AND (#" & dteValTo & "#))"

 

[nat1967]

Hi,

You had a little more going on than I expected.

Try this and let me know.

DoCmd.OpenReport stDocName, acViewPreview, , "Country='" & strVal & "'" & _
"AND [FromDate] BETWEEN (#" & dteValFrom & "#) AND (#" & dteValTo & "#)" & _
"OR ToDate BETWEEN (#" & dteValFrom & "#) AND (#" & dteValTo & "#))" Have A Great Day!!!,

Nathan
Senior Test Lead

 

[Rmcta]

I copied your code and pasted it over mine but again it becomes yellow.

 

[nat1967]

Hi,

Hmmm....I do see a parenthese missing. Try this and let me know.

DoCmd.OpenReport stDocName, acViewPreview, , "Country='" & strVal & "'" & _
"AND ([FromDate] BETWEEN (#" & dteValFrom & "#) AND (#" & dteValTo & "#)" & _
"OR ToDate BETWEEN (#" & dteValFrom & "#) AND (#" & dteValTo & "#))" Have A Great Day!!!,

Nathan
Senior Test Lead

 

[MichaelRed]

How about actually USING the built in HELP? Many of the examples use line continuation and help actually cover the topic. It should be covered by any beginner's class on hte (programming) language!

MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[Rmcta]

Yes Nathan,
It works. GREAT! Thank you very much

 

[nat1967]

glad i could help. Have A Great Day!!!,

Nathan
Senior Test Lead