Replace Function (Access custom web app)

Replaces all occurrences of a specified string value with another string value.

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.

Syntax

Replace (TextExpression, Pattern, Replacement)

The Replace function contains the following arguments.

Argument name	Description
TextExpression	The string expression to be searched.
Pattern	The substring to be found. Pattern cannot be an empty string ("").
Replacement	The replacement string.