ReturnVar object (Access)

Represents a variable that was initialized by the SetReturnVar function in a Data Macro.

Remarks

A ReturnVar object provides a convenient way to use values set in a Data Macro.

Although a ReturnVar 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 ReturnVar object remains in memory until the next time the RunDataMacro method is used.

A ReturnVar object can store only text or numeric data. ReturnVar 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.

ReturnVars![name] 

Properties

• Name
• Value

See also

• Access Object Model Reference

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.