Others

How to Display Friendly Hyperlink Names in Microsoft Access

Adam DavisAdam Davis Nov 4, 2026 870 views

Question details

The user wants to display descriptive, readable text for hyperlinks in Microsoft Access databases instead of showing the full, lengthy URL string.

How to Display a Friendly Hyperlink Name in Microsoft Access
Product
Microsoft Access
Device & OS
not provided
Scenario
Organizing external links, such as Google Drive addresses, within a database table or report while maintaining readability.
Observed behavior
By default or when improperly formatted, hyperlink fields display the entire underlying URL, which can be visually cluttered and difficult for end-users to read.
Before you start

Verify that your target field is configured with the 'Hyperlink' data type in your table's Design View, as standard text fields will not parse the formatting syntax correctly.

Solution 1Recommended

Format the Hyperlink Using Hashtag Syntax

Use Access's built-in, specific formatting syntax to separate your desired display text from the actual URL.

Microsoft Access handles hyperlinks in a multi-part format separated by the pound or hashtag symbol (#). To change the displayed text, you must manually type or structure the data using this specific syntax rather than just pasting the URL directly.

1
Select the hyperlink cell

Open your Microsoft Access table in Datasheet View, or open a Form that contains the hyperlink field you wish to edit.

2
Enter the formatted hyperlink string

Type the text exactly using the format: Display Text#URL##. For example, to link to a sheet music file, you would enter: French Horn Sheet Music Link#https://example.com/sheetmusic##.

3
Save the record

Press the Enter key or click out of the field to save the record. The field will immediately hide the URL and the trailing hashtags, displaying only 'French Horn Sheet Music Link' as a clickable blue link.

Format the Hyperlink Using Hashtag Syntax
Database Naming Best Practices: When configuring databases, avoid using spaces or unusual special characters in database object names (like table or field names), as this can cause syntax errors when trying to run queries or reports on these hyperlink fields.
Free Microsoft Office alternative

Looking for a Lightweight, Everyday Office Suite?

While Microsoft Access is a dedicated database tool, managing basic data lists and inserting friendly hyperlinks is often easier in a robust spreadsheet program. WPS Office provides a powerful, free alternative for word processing, spreadsheets, and presentations without complex formatting rules.

Easily insert and manage friendly display text for hyperlinks in WPS Spreadsheet without typing out complex hashtag syntax.Highly compatible with Microsoft Excel, Word, and PowerPoint formats (xlsx, docx, pptx).Lightweight architecture ensures smooth performance on almost any PC or mobile device.Free to use with a familiar, easy-to-navigate user interface for seamless migration.
microsoft office alternative - wps office

Frequently Asked Questions

Can I use a calculated field in Access to show both the friendly name and full URL in different reports?

Microsoft Access does not natively allow you to split the display text and URL into separate report columns using simple calculated fields. Instead, you need to use VBA functions, specifically the HyperlinkPart function, to extract either the display text (acDisplayText) or the URL address (acAddress) within queries or reports.

Why is my hyperlink field showing the hashtags instead of converting to a clickable link?

This happens if the field is set to the 'Short Text' or 'Long Text' data type. You must switch to 'Design View' for your table and change the data type of that specific column to 'Hyperlink' so Access knows to interpret the hashtags as formatting delimiters.

How do I insert friendly hyperlinks in other Office programs like Excel or WPS Spreadsheet?

In spreadsheet programs like WPS Spreadsheet or Excel, you do not need the hashtag syntax. Simply right-click a cell, select 'Hyperlink' (or 'Link'), and fill out the 'Text to display' and 'Address' boxes in the dialog window.