Class TempVar (Access VBA)

The class TempVar represents a variable that can be used in Visual Basic for Applications (VBA) code or from a macro. To use a TempVar class variable it first needs to be instantiated, for example

Name

Gets the name of the specified TempVar object.

TempVars(1).Name

Value

Gets or sets the value of the specified TempVar variant. Read/write Variant.

A TempVar can store only numeric or text data. Setting the Value property to an Object data type will result in a run-time error.

TempVars(1).Value =