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. If the property takes parameters, follow the Property keyword with the name of the procedure, then the parameter list in. Outside any property or procedure, use a Property Statement, followed by an End Property statement. ' Assign object property of control to variable. For a read-only property, you define only Get, and for a write-only property, you define only Set. Sub PrintFormLetter_Click()ĭim strCustomer As String, strAddress As Stringĭim strCity As String, strRegion As String It doesn't save copies of the printed form letter. The procedure replaces the placeholder information for each record and prints the form letter. Customer name and address information is inserted in an embedded Microsoft Word document formatted as a form letter with placeholders for the name and address information and boilerplate text in the body of the letter. The following example uses the Object property of an unbound object frame named OLE1. You can then use any of the properties and methods of the Worksheet object.įor information about which properties and methods an ActiveX object supports, see the documentation for the application that was used to create the OLE object. If you've embedded an Excel worksheet in an Access form, you can use the Object property to set a reference to the Worksheet object associated with that worksheet. For example, Microsoft Excel is a COM component that supports Automation. By using this reference, you can change the OLE object by setting or reading its properties or applying its methods.

The Object property returns a reference to an Automation object that represents the linked or embedded OLE object. However, you can't directly set or read the OLE object's properties or apply its methods, as you can when performing Automation.

When you embed or link an OLE object in a Microsoft Access form, you can set properties that determine the type of object and the behavior of the container control. The type of object reference returned depends on which application created the OLE object. Use the Set statement to assign this ActiveX object to an object variable. The Object property returns a reference to an ActiveX object. SyntaxĮxpression A variable that represents a Control object. By using this reference, you can access the properties or invoke the methods of the OLE object. Use the Object property in Visual Basic to return a reference to the ActiveX object that is associated with a linked or embedded OLE object in a control.

Vb get activex property