Replace Function (Access custom web app)

Office 2013 and later

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

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.

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.
Show: