Problem with start parameter of INSTR()

F

Fred Boer

Hello:

In an immediate window, I enter the following (with the results displayed).
Shouldn't the second example return "5", since I am using the "start"
parameter?

?instr("This is a test","a")
9
?instr(4,"This is a test","a")
9
?instr(4,"This is a test","a",vbTextCompare)
9
?instr(4,"This is a test","a",vbBinaryCompare)
9

Thanks!
Fred "Puzzled" Boer

Windows XP Pro
Access 2003
 
J

Joshua A. Booker

Fred,

The start parameter just specifies where to start the compare. The result
will still be the first found position (after start) within the entire
string.

HTH,
Josh
 
D

Douglas J Steele

No, it's telling you that the first a appears at position 9 in the string.

?instr("Another test to find a in the string", "a")
1
?instr(4, "Another test to find a in the string", "a")
22

Here, it finds that the first "a" after position 4 is the 22nd character in
the string.
 
Top