Others

Fix Hyperlinks in a Microsoft Access Split Form Datasheet

Chanuka GeekiyanageChanuka Geekiyanage Nov 14, 2026 868 views

Question details

The user needs hyperlinks to open from the datasheet section of an Access split form.

Fix Hyperlinks in a Microsoft Access Split Form Datasheet
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the control properties

Open the form in Design View, select the control containing the plain URL, and open the Property Sheet. Note the control's name.

2
Create a Click event procedure

On the Property Sheet's Event tab, set On Click to [Event Procedure], then select the build button to open the VBA editor.

3
Add the hyperlink code

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.

4
Test the datasheet

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.

Use a Click event to open a single URL
Multiple links need separate handling: Do not pass an entire rich-text value with multiple links to FollowHyperlink as though it were one URL. Open only addresses you trust.
Free Microsoft Office alternative

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.

Open exported Access table data in a spreadsheet for reviewWork with Microsoft Word, Excel, and PowerPoint formatsUse a familiar interface for common office tasksChoose a free, lightweight office suite
microsoft office alternative - wps office

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.