SQL to populate a hyperlink column in MS Access

Question

I imagine the SQL must pass 2 values, the value shown in the table and the link to which that value navigates.

I'd appreciate a pointer to the SQL Script for achieving this. Thanks.

Answer 1

The format for a hyperlink column (field) is:

Description#Address#

For example:

This is StackOverflow#http://stackoverflow.com#
Mr E Xample#mailto:[email protected]#

For the most part, I prefer to avoid hyperlink fields (columns) as editing them is a real problem. A text or memo field with a little code is much simpler, though you will need a form.