followhyperlink command displays a #

[Lloyd]

I have a field in the table ImageDocLoc with a datatype of Hyperlink. I have
added a command button to the form to launch the hyperlink address when
selected based on the field in the table. The code is:

FollowHyperlink CaseImageLoc

When the button is pushed, the code attempts to launch the hyperlink but
displays an error that it cant follow the hyperlink '#http://mylocaiton#

The problem is the # signs that are being place at the start and end of the
URL. From the reading I have done, this is used to launch a file/unc path
location, but I need it to launch a browser and go to our intranet. How do I
get the # signs to not be part of the URL?

 

[Ken Snell \(MVP\)]

If you're going to use the FollowHyperlink method to launch the "hyperlink",
then change the data type of the field to Text -- don't use Hyperlink data
type. The Hyperlink data type is intended to let you click directly on the
value in the field and have it be a hyperlink; this is not needed if you use
FollowHyperlink code.