&
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"