How to reset global variables to nothing

[Paul]

In a form I store the value of the text box to the global variables in a
module. At some point I need to reset those variables in the module to
nothing. So I tried the following code in the form event, Set
GlobalVariable.Text1 = Nothing or GlobalVariable = vbNullString and both
does not work. Thanks.

 

[Allen Browne]

Unlike some languages, VB/VBA sets the initial value of the variable when
you declare it. Therefore the way to reset it depends on its type.

For numeric types (Integer, Long, Double, Currency, etc), just assign a
zero:
MyGlobal = 0

For String types, assign a zero-length string:
MyGlobal = vbNullString

For Variants, assign the value Empty:
MyGlobal = Empty

For objects (Form, Control, TextBox, Recordset, etc), set to Nothing:
Set MyGlobal = Nothing

 

[Paul]

How about if the variable is the "date" type??

Unlike some languages, VB/VBA sets the initial value of the variable when
you declare it. Therefore the way to reset it depends on its type.

For numeric types (Integer, Long, Double, Currency, etc), just assign a
zero:
MyGlobal = 0

For String types, assign a zero-length string:
MyGlobal = vbNullString

For Variants, assign the value Empty:
MyGlobal = Empty

For objects (Form, Control, TextBox, Recordset, etc), set to Nothing:
Set MyGlobal = Nothing

 

[Allen Browne]

Assign the zero date/time, i.e.:
MyGlobal = #0:00:00#