Access VBA find the last occurrent of a string?

Question

Access VBA has Instr to return the position of the first occurrence of a string in another string.

Instr ( [start], string_being_searched, string2, [compare] )

Is there any method to return the position of the last occurrence of a string in another string?

score 17 · Accepted Answer · answered Jul 04 '13 at 02:39

17

Try InstrRev instead - see here

Note the different syntax to InStr:

InstrRev(stringcheck, stringmatch[, start[, compare]])

answered Jul 04 '13 at 02:39

barrowc

10,444
1
40
53

1

Good answer! This is not specific to MS Access. It will work anywhere VBA is used. – ChrisB Apr 09 '18 at 19:18

score 2 · Answer 2 · answered Apr 20 '17 at 20:33

Check this link, example code from MS

https://msdn.microsoft.com/en-us/library/t2ekk41a(v=vs.90).aspx

Dim TestString As String = "the quick brown fox jumps over the lazy dog" 
Dim TestNumber As Integer 
' Returns 32.
TestNumber = InStrRev(TestString, "the")
' Returns 1.
TestNumber = InStrRev(TestString, "the", 16)

Access VBA find the last occurrent of a string?

2 Answers2