Stuff Function (Access custom web app)
Inserts a text string into another text string. It deletes a specified length of characters in the first string at the start position and then inserts the second string into the first string at the start position.
Last modified: March 09, 2015
Applies to: Access 2013 | Access 2016
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. |
Stuff (IntoTextExpression, Start, Length, ThisTextExpression)
The Stuff function contains the following arguments.
|
Argument name |
Description |
|---|---|
|
IntoTextExpression |
A text expression that specifies the text into which the text specified by the ThisTextExpression will be inserted. |
|
Start |
An integer value that specifies the location to start deletion and insertion. If start or length is negative, a null string is returned. If start is longer than the first IntoTextExpression, a null string is returned. |
|
Length |
An integer that specifies the number of characters to delete. If length is longer than the first IntoTextExpression, deletion occurs up to the last character in the last IntoTextExpression. |
|
ThisTextExpression |
A text expression hat specifies the text to insert into IntoTextExpression. This expression will replace length characters of IntoTextExpression beginning at Start. |
If the Start or Length arguments are negative, or if the starting position is larger than length of the first string, a null string is returned. If the start position is 0, a null value is returned. If the length to delete is longer than the first string, it is deleted to the first character in the first string.