Jeremy Leach
Senior Member
Hi
I've encountered a strange issue. I've got a very long lookup command that wraps onto two lines of code. This seems to be causing unexpected problems in execution, although the syntax checker thinks it's ok.
How do I get round this? Is there some sort of continuation symbol in the program editor - e.g VBA uses "_" to mean that the command continues on the next line ?
The command I'm using is :
Lookup RecordIndex,(0,5,10,16,22,27,34,42,50,55,60,65,69,74,82,84,92,95,100,105,108,111,117,124,126,129,135,143,147,152,159,162,167,171,178,182,187,189,191,193,195,197,199,201,203,205,206,209,213,18,222,222,228),Address
I've encountered a strange issue. I've got a very long lookup command that wraps onto two lines of code. This seems to be causing unexpected problems in execution, although the syntax checker thinks it's ok.
How do I get round this? Is there some sort of continuation symbol in the program editor - e.g VBA uses "_" to mean that the command continues on the next line ?
The command I'm using is :
Lookup RecordIndex,(0,5,10,16,22,27,34,42,50,55,60,65,69,74,82,84,92,95,100,105,108,111,117,124,126,129,135,143,147,152,159,162,167,171,178,182,187,189,191,193,195,197,199,201,203,205,206,209,213,18,222,222,228),Address