CharIndex Function (Access custom web app)

Office 2013 and later

Searches a text expression for another text expression and returns its starting position if found.

Last modified: March 09, 2015

Applies to: Access 2013 | Access 2016

Important note Important

Microsoft no longer recommends creating and using Access web apps in SharePoint. As an alternative, consider using Microsoft PowerApps to build no-code business solutions for the web and mobile devices.

CharIndex(TextExpression, WithinText, [Start])

Argument Name

Required

Description

TextExpression

Yes

A text expression that contains the text to be found.

WithinText

Yes

The text expression to be searched.

Start

No

An integer that specifies the location in WithinText to begin the search. If Start is not specified, is a negative number, or is 0, the search starts at the beginning of WithinText.

If either TextExpression or WithinText is NULL, CharIndex returns NULL.

If TextExpressionis not found within WithinText, CharIndex returns 0.

The starting position returned is 1-based, not 0-based.

Show: