Dolphin.com.bd

Office Suite Tutorial => Microsoft Office Access => Topic started by: bbasujon on August 15, 2012, 05:21:52 PM

Title: Microsoft Access Function Library: InStr()
Post by: bbasujon on August 15, 2012, 05:21:52 PM

Function: InStr()

Purpose: The InStr() function returns a number corresponding to the first location of a substring within a string.

Usage: InStr([start,] string, substring [,compare])

Start is an option argument specifying the location within the string to start searching. If you do not specify a starting location, Access uses the default value of 1.
String is the string you wish to search within.
Substr is the substring you wish to locate within String.
Compare is an optional argument specifying the type of comparision you wish to use. The possible values are:

    vbUseCompareOption uses the Option Compare statement’s setting. This is the default setting.
    vbBinaryCompare uses a binary comparison.
    vbTextCompare uses a textual comparison.