hyperlink field not using hyperlink base

[Mary]

I have a table with a hyperlink field. I have set the
hyperlink base in the database properties to c:\folder.

I want the user to be able to type in the document name in
the field without having to use the "insert hyperlink"
button.

When I type in a document name, tab out of the field, and
then click the name, Access tries to open http://document.
Why doesn't it use the hyperlink base?

I can't imagine that this is a new problem, but I have
searched on Google newsgroups archive and here and have
not found an answer.

I am using Access 2000 on windows 2K.

Thanks.

Mary

 

[Allen Browne]

Just use a text field instead of a hyperlink.

You can then concatenate the folder name and the document name together, and
use the result with FollowHyperlink, e.g.:
Application.FollowHyperlink "C:\MyFolder\" & "MyFile.txt"

 

[Mary]

Thank you, Allen. That's easier than trying to write code
to remove the http:// of the link address after the user
types in something.

Mary