SubAddress Property

Microsoft Access Visual Basic

property. The SubAddress property can be an object within a Microsoft Access database, a bookmark within a Microsoft Word document, a named range within a Microsoft Excel spreadsheet, a slide within a Microsoft PowerPoint presentation, or a location within an HTML document. Read/write String.

expression.SubAddress

expression    Required. An expression that returns one of the objects in the Applies To list.

Remarks

The SubAddress property is a string expression representing the HyperlinkSubAddress property of a named location within the target document specified by the HyperlinkAddress property

You can set the HyperlinkSubAddress property with the SubAddress property by using Visual Basic.

Note  You can set the HyperlinkSubAddress property by using a control's property sheet, a macro, or Visual Basic.

When you move the cursor over a command button, image control, or label control whose HyperlinkSubAddress property is set, the cursor changes to an upward-pointing hand. Clicking the control displays the object or Web page specified by the link.

For more information about hyperlink addresses and their format, see the HyperlinkAddress and HyperlinkSubAddress property topics.

Example

The following example turns a label named "Label20" on the "Suppliers" form into an active hyperlink. When the user click the hyperlink, Access opens the "Mailing List" form in the "Postal Operations" database.

With Forms("Suppliers").Controls("Label20").Hyperlink
    .Address = "PostalOperations.mdb"
    .SubAddress = "Form Mailing List"
End With