Concat Function (Access custom web app)

Office 2013 and later

Returns a string that is the result of combining two or more string values.

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.

Concat(Value1, Value2, …[ValueN])

The Concat function contains the following arguments.

Argument Name

Description

Value

A string value to concatenate to the other values.

Concat takes a variable number of string arguments and concatenates them into a single string. A minimum of two string arguments are required; otherwise, an error is raised.

All arguments are implicitly converted to string data types and then concatenated.

The following expression can be used to display the full name of a person where the table contains FirstName, MiddleInitial, and LastName fields. If the MiddleInitial field is blank, then only the FirstName and LastName fields are combined to display the full name,

Copy 
IIf([MiddleInitial] Is Null,Concat([FirstName]," ",[LastName]),Concat([FirstName]," ",[MiddleInitial]," ",[LastName]))
Show: