Visual Basic for Applications Reference
InStrRev Function
See Also Example Specifics
Description
Returns the position of an occurrence of one string within another, from the end of string.
Syntax
InstrRev(stringcheck,stringmatch[,start[,compare]])
The InstrRev function syntax has these named arguments:
| Part | Description |
| stringcheck | Required. String expression being searched. |
| stringmatch | Required. String expression being searched for. |
| start | Optional. Numeric expression that sets the starting position for each search. If omitted, 1 is used, which means that the search begins at the last character position. If start contains
Null, an error occurs. |
| compare | Optional. Numeric value indicating the kind of comparison to use when evaluating substrings. If omitted, a binary comparison is performed. See Settings section for values. |
Settings
The compare argument can have the following values:
| Constant | Value | Description |
| vbUseCompareOption | 1 | Performs a comparison using the setting of the Option Compare statement. |
| vbBinaryCompare | 0 | Performs a binary comparison. |
| vbTextCompare | 1 | Performs a textual comparison. |
| vbDatabaseCompare | 2 | Microsoft Access only. Performs a comparison based on information in your database. |
Return Values
InStrRev returns the following values:
| If | InStrRev returns |
| stringcheck is zero-length | 0 |
| stringcheck is Null | Null |
| stringmatch is zero-length | start |
| stringmatch is Null | Null |
| stringmatch is not found | 0 |
| stringmatch is found within stringcheck | Position at which match is found |
| start > Len(stringmatch) | 0 |
Remarks
Note that the syntax for the InstrRev function is not the same as the syntax for the Instr function.