Edit

Share via

Replace Function (Access custom web app)

  • Article

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.