Hyperlink in Access Query how to?

[Tommylux]

Hi there,

In an access 2000 append query, one of my fields is based on the
expression:
[Settings]![ConPath] & "\" & [Contacts]![FName] & "." &
[Settings]![ConExt]

It is appended into a hyperlink field type in a local table and when
you open the table, it looks like a hyperlink, with the full path, but
when clicked, does nothing.

When you right click and edit the hyperlink, the data I have appended
in, appears under the Text to display, but the actual hyperlink path,
is null.

Any ideas to change the query so that I am appending into the
hyperlink? I am expecting there is a function in the query properties
such as:

Hyperlink([Settings]![ConPath] & "\" & [Contacts]![FName] & "." &
[Settings]![ConExt],"Text To display")

Or something similar

Cheers

 

[Allen Browne]

At minimum, a Hyperlink consists of these parts:
- an address to display
- #
- an address to link to
- #

Try assigning:
[Settings]![ConPath] & "\" & [Contacts]![FName] & "." &
[Settings]![ConExt] & "#" & [Settings]![ConPath] & "\" & [Contacts]![FName]
& "." & [Settings]![ConExt] & "#"

More info:
Introduction to Hyperlink fields
at:
http://allenbrowne.com/casu-09.html

 

[Tommylux]

Thanks Allen,

This works great, I knew it was something simple.

Tom