format is an optional argument

Formatting Functions

FormatDateTime(expression, format) is used to format the date/time

data in expression. format is an optional argument that should be one of the

following:

§ vbGeneralDate Display date, if present, as short date. Display time, if

present, as long time. Value is 0. This is the default setting if no format is

specified.

§ vbLongDate Display date using the server's long date format. Value is 1.

§ vbShortDate Display date using the server's short date format. Value is 2.

§ vbLongTime Display time using the server's long time format. Value is 3.

§ vbShortTime Display time using the server's short time format. Value is

FormatCurrency (value, numdigits, leadingzero, negparen,

delimiter) is used to format the monetary value specified by value.

§ numdigits specifies the number of digits after the decimal place to

display. -1 indicates to use the system default.

§ Tristate options have three possible values. If the value is -2, it means

use the system default. If it is -1, it means turn on the option. If it is 0, turn

off the option.

§ leadingzero is a Tristate option indicating whether to include leading

zeroes on values less than 1.

§ negparen is a Tristate option indicating whether to enclose negative values

in parentheses.

§ delimeter is a Tristate option indicating whether to use the delimiter

specified in the computer's settings to group digits.

FormatNumber is used to format numerical values. It is almost exactly like

FormatCurrency, only it does not display a dollar sign.

FormatPercent works like the previous two. The options are the same, but it

turns the value it is given into a percentage.