You can concatenate numeric values into a string expression without having to
convert their data type first, e.g.

Const conFirst = "Your current Total is "
Const conSecond = " Exclusive of Shipping"
Dim strDisplay As String

strDisplay = conFirst & [InvoiceTotal] & conSecond

Note that constants have been used here for the two literal strings.  There
is no need to declare these as variables as they are unchanging.  Note the
spaces at the end of the first literal string and start of the second.

Invoice Total is presumably a field in the underlying recordset  of the form
or report in whose module the code is executing.  Note that in a report's
module you can only refer to a control bound to the field, not directly to
the field in the underlying recordset as you can in a form's module.

Ken Sheridan
Stafford, England