Visual Basic 6.0 Run-Time Error with InStr?

Question

The following line of code is giving me "Run-Time Error '5': Invalid procedure call or argument."

foundString = InStr(start, events(i), CODE_TAG_LEFT, vbBinaryCompare)

foundString is an integer, start is an integer (in this case it is equal to zero), events() is a string array, and CODE_TAG_LEFT is a const string. If anyone could point out what my error is, I would greatly appreciate it.

Answer 1

The first character in the string is 1, not 0 - you're pointing before the beginning of the string. (Leave the index out if you're starting at the first character - that's the default.)

Answer 2

Visual Basic Instr

Answer 3

A null value from a recordset many times shows that (a) you have misnamed the guidance field "StudCourse", or (b) there's a null value interior the certainly field "StudCourse", which could't be assigned to I.SubItems(2). If (a) is the project, purely correcting the fieldname might desire to restore the code. If (b) is the project, attempt changing: l.SubItems(2) = rs!StudCourse With: l.SubItems(2) = iif(isnull(rs!StudCourse),"",rs!StudCour... that would desire to assign an empty string somewhat interior the case the place StudCourse is null.

Answer 4

Vb6 Instr