I tried that but it keeps putting square brackets around the vbCrLf?Code:& vbCrLf
Yes, on a textbox on a form.Where is this? An expression for the ControlSource of some control on a form or report?
=[Street Address] & vbCrLf & [Street Address Line 2] & " " & [City]=[Street Address] & [vbCrLf] & [Street Address Line 2] & [City]
That did it!vbCrLf is a VBA constant. The Expression Service does not know about those. Replace with:
=[City] & Chr(13) & Chr(10) & [Zip]
The expression service *and* VBA know about the Chr function.
You make use of the + operand and how it handles null differently from the normal concatenation operator.=[Street Address] & Chr(13) & Chr(10) & [Street Address Line 2] & Chr(13) & Chr(10) & [City] & ", " & [State] & " " & [Zip Code]