TempVar object (Access)

Represents a variable that can be used in Visual Basic for Applications (VBA) code or from a macro.


TempVar objects provide a convenient way to exchange data between VBA procedures and macros.

Although a TempVar object can be used to store information for use in VBA procedures, it does not have the same functionality as a VBA variable.

  • By default, a TempVar object remains in memory until the Database is closed. Use the Remove method or the RemoveTempVar macro action to remove a TempVar object.

  • In VBA, a TempVar object is accessible only to the members of the Access Application object, referenced databases, or add-ins.

  • A TempVar object can store only text or numeric data. TempVar objects cannot store objects.

To refer to a TempVar object in a collection by its ordinal number or by its Name property setting, use the following syntax form:

  • TempVar![name]


See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.