TempVars Object
Collapse the table of content
Expand the table of content

TempVars Object (Access)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Represents the collection of TempVar objects.

Use the Add method or the SetTempVar macro action to create a TempVar object.

Use the Remove method or the RemoveTempVar macro action to delete a TempVar object from the TempVars collection.

Use the RemoveAll method or RemoveAllTempVars macro action to delete all TempVar objects from the TempVars collection.

The TempVars collection can store up to 255 TempVar objects. If you do not remove a TempVar object, it will remain in memory until you close the database. It is a good practice to remove TempVar object variables when you are finished using them.

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]

© 2015 Microsoft