CommandButton.HyperlinkSubAddress property (Access)
Use the HyperlinkSubAddress property to specify or determine a location within the target document specified by the HyperlinkAddress property. Read/write String.
Syntax
expression.HyperlinkSubAddress
expression A variable that represents a CommandButton object.
Remarks
The HyperlinkSubAddress 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.
The HyperlinkSubAddress property is a string expression that represents a named location within the target document specified by the HyperlinkAddress property.
Note
When you create a hyperlink by using the Insert Hyperlink dialog box, Access automatically sets the HyperlinkAddress property and HyperlinkSubAddress to the location specified in the Type the file or webpage name box. The HyperlinkSubAddress property can also be set to the location specified in the Select an object in this database box.
If you copy a hyperlink from another application and paste it into a form or report, Access creates a label control with its Caption property, HyperlinkAddress property, and HyperlinkSubAddress property automatically set.
When you move the cursor over a command button, image control, or label control whose HyperlinkAddress property is set, the cursor changes to an upward-pointing hand. Choosing the control displays the object or webpage specified by the link.
To open objects in the current database, leave the HyperlinkAddress property blank and specify the object type and object name that you want to open in the HyperlinkSubAddress property by using the syntax objecttype objectname. If you want to open an object contained in another Access database, enter the database path and file name in the HyperlinkAddress property and specify the database object to open by using the HyperlinkSubAddress property.
The HyperlinkAddress property can contain an absolute or a relative path to a target document. An absolute path is a fully qualified URL or UNC path to a document. A relative path is a path related to the base path specified in the Hyperlink Base setting in the Properties dialog box (available by choosing Database Properties on the File menu) or to the current database path. If Access can't resolve the HyperlinkAddress property setting to a valid URL or UNC path, it will assume that you have specified a path relative to the base path contained in the Hyperlink Base setting or the current database path.
Note
When you follow a hyperlink to another Access database object, the database Startup properties are applied. For example, if the destination database has a Display form set, that form is displayed when the database opens.
The following table contains examples of HyperlinkAddress and HyperlinkSubAddress property settings.
| HyperlinkAddress | HyperlinkSubAddress | Description |
|---|---|---|
| https://www.microsoft.com/ | The Microsoft home page on the web. | |
| C:\Program Files\Microsoft Office\Office\Samples\Cajun.htm | The Cajun Delights page in the Access sample applications subdirectory. | |
| C:\Program Files\Microsoft Office\Office\Samples\Cajun.htm | NewProducts | The "NewProducts" Name tag on the Cajun Delights page. |
| C:\Personal\MyResume.doc | References | The bookmark named "References" in the Microsoft Word document MyResume.doc. |
| C:\Finance\FirstQuarter.xls | Sheet1!TotalSales | The range named "TotalSales" in the Microsoft Excel spreadsheet FirstQuarter.xls. |
| C:\Presentation\NewPlans.ppt | 10 | The tenth slide in the Microsoft PowerPoint document NewPlans.ppt. |
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.