#### Passing optional arguments

- Many arguments for the ToText function have been specified as optional. However, you can only leave an argument blank if all the arguments that follow it are left blank as well. In other words, you can not leave the y and z arguments blank and provide an argument for w. It is possible, however, to leave one, two, or all of the optional arguments blank, as long as no arguments are supplied after the blank arguments.

  The following combinations are possible when supplying arguments to the ToText function:

  - ToText(x)
  - ToText (x, y)
  - ToText (x, y, z)
  - ToText (x, y, z, w)
  - ToText (x, y, z, w, q)
- Using the "t" or "tt" format characters in a time format string provides default strings for indicating a.m. (morning) and p.m. (evening) hours. "t" produces just a single character, "a" or "p", while "tt" produces the entire string, "am" or "pm". You can pass your own custom strings for indicating am/pm strings. See the arguments for converting time and DateTime values with ToText in the Arguments section of ToText.)

  If you do pass your own am/pm strings, the "t" and "tt" format characters will have the same effect on them (producing single character vs. multiple character strings). However, the "t" and "tt" format characters are optional and only necessary when default am/pm strings are needed.

###### Related topics

CStr

Formula 1

Formula 2

Formula 3

Formula 5

Formula 13

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com