&

Use the & function to force string concatenation between two expressions.

Whenever an expression is not a string, it is converted to a String subtype. If both expressions are Null, then the result is also Null. Any expression that is empty is treated as a zero-length string.

Syntax

expression1 & expression2

Examples

  • "Today's date is " & Today()

    This example returns "Today's date is 10/20/2018"

  • "Today's date is " & Now()

    This example returns "Today's date is 10/30/2018 10:27:13 AM"