Default values for the simple types

An uninitialized variable will have the default value for its type. In general, it is not a good programming practice to rely on the default values of types. For example, initialize all local variables in your formula, initialize all global variables in a formula placed in the Report Header, and initialize all shared variables in a formula placed in the Report Header of the main report.

When an array is resized using the Redim keyword, the entries are filled with default values for the type.

Default values

Number

0

Currency

CCur (0)

String

"" 'The empty string

Date

CDate (0, 0, 0) 'The null Date value

Time

The null Time value. Value held by an uninitialized Time variable.

DateTime

The null DateTime value. Value held by an uninitialized DateTime variable.

Note:    It is not recommended that your formulas rely on the values of uninitialized range or array variables.