Table of contents
TOC
Collapse the table of content
Expand the table of content

TempVar Object (Access)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

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

Remarks

A 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 funcitonality as a VBA variable.

  • By default, a TempVar object remains in memory until Access is closed. You can use the Remove method or theRemoveTempVar 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]
Name
Name
Value

See also

Other resources

Access Object Model ReferenceTempVar Object Members

© 2017 Microsoft