hyperlink field not using hyperlink base

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

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"

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Mary" wrote in message
...
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

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

-----Original Message-----
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"

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Mary" wrote in
message
...
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


.