How to Display Friendly Hyperlink Names in Microsoft Access
Question details
The user wants to display descriptive, readable text for hyperlinks in Microsoft Access databases instead of showing the full, lengthy URL string.

- 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.
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.
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.
Open your Microsoft Access table in Datasheet View, or open a Form that contains the hyperlink field you wish to edit.
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##.
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.

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.

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.




