Fix Hyperlinks in a Microsoft Access Split Form Datasheet
Question details
The user needs hyperlinks to open from the datasheet section of an Access split form.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A split form displays a rich-text field that may contain multiple hyperlinks.
- Observed behavior
- Links work in standard form views but may not respond as expected in the split form datasheet.
Open the form in Access and identify the affected control and its source field. Check whether the field contains a single plain URL or rich text with multiple links, since those cases need different handling.
Use a Click event to open a single URL
Use this approach when a control contains one plain URL and its Click event runs in the split form datasheet.
FollowHyperlink opens the address you supply; it does not identify which link was clicked inside a rich-text field containing multiple links.
Open the form in Design View, select the control containing the plain URL, and open the Property Sheet. Note the control's name.
On the Property Sheet's Event tab, set On Click to [Event Procedure], then select the build button to open the VBA editor.
Inside the generated Click procedure, add: If Not IsNull(Me!UrlText) Then Application.FollowHyperlink CStr(Me!UrlText). Replace UrlText with the name of your control containing a plain URL.
Save the form, open it in Form View, and click the URL control in the split form's datasheet. If the event does not run there, use a separate hyperlink field or open the link from a standard form view.

Store individual links in separate hyperlink fields
Use separate fields when users need to open specific links from content that currently contains multiple hyperlinks.
Use WPS Office for Documents and Spreadsheets
WPS Office is a free, lightweight alternative with a familiar interface for working with Office documents and spreadsheets. You can migrate exported Access table data to a spreadsheet, but WPS does not fix Access split forms or replace Access database functionality.

Frequently Asked Questions
Why do links work in a regular Access form but not in the split form datasheet?
The datasheet section can handle clicks differently from a standard form view, especially for rich-text fields with multiple links. Test the control in both sections to see where the link responds.
Can FollowHyperlink open a specific link in a rich-text field?
FollowHyperlink needs an address to open; it does not automatically determine which link was clicked inside a field containing multiple links. Store the needed addresses separately or use another way to identify the intended address.
Where do I add a Click event in Access?
Open the form in Design View, select the control, and use the Event tab of the Property Sheet. Set On Click to [Event Procedure] and select the build button to edit the VBA procedure.
What if the Click event does not run in the datasheet?
Test the same control in the form section or a standard form view. If the datasheet still does not respond, provide a separate hyperlink control or field that users can open from the form view.




