Formatting Hyperlinks in an Access 2007 Databas
Formatting hyperlinks in an Access 2007 database is more complex than adding links in other Microsoft Office applications. Remember that there is only one mandatory component to adding a hyperlink to a data table’s cell; the Web address is the only mandatory component. To add only a hyperlink to a data table’s cell, simply type in the link using the following format:
Access will then display the following hyperlink in the cell as:
To add display text as discussed above, you need to use a pound (#) symbol to separate the display text from the hyperlink text. To add the display text “Some Domain" to the hyperlink, format the link like this:
Some Domain# http:// www.somedomain.com#
Notice that there is an extra # symbol at the end of the hyperlink. This is because the pound symbol is used to separate all of the options in an Access 2007 hyperlink and you need to tell Access where one option ends and another begins.
To add a sub-address to the hyperlink, format the link like this:
Some Domain# http:// www.somedomain.com#somesubaddress#
Notice again that the hyperlink ends in a # symbol. This is used to tell Access that the hyperlink has ended and includes everything we want it to include. To include all four options in the hyperlink, format the link like this:
Some Domain# http:// www.somedomain.com#somesubaddress#This is a screen tip#
Therefore, the general format for a hyperlink in Access 2007 is:
If you want to skip one of the options, you need to use a double pound to tell Access that the option in question is purposely missing. For example, suppose you want to have a hyperlink that has some display text (optional), an address (mandatory), no sub-address (optional), and a screen tip. You would format that hyperlink like this:
Some Domain# http:// www.somedomain.com##This is a screen tip#
Notice the double # symbol between the address and the screen tip. This double pound is used as a placeholder to show that the sub-address was intentionally left blank.