Hyperlink not clickable

[Michael]

I have two forms:

One is a simple continuous form bound diretly to a table where one of the
fields is a hyperlink. When displayed the hyperlink field is, blue,
underlined and clickable; the cursor changes to a hand as the mouse passes
over it and on clicking the web page is displayed.

On the other continuous form (for good reasons) a text field is populated
with the hyperlink value from the table. The text field property is set to
Hyperlink=Yes and the data is displayed as a hyperlink but:

Firstly, it has hashes at the beginning and end, and, secondly, it is not
clickable (i.e. mouseover does not change cursor to a hand).

Can anyone help me please with these two anomalies?

Many thanks,

Michael.

 

[Jack Leach]

Try staying away from the hyperlink field in the table... it stores extra
information with the link that isn't necessarily required. Instead, store
the hyperlink as text, and set the Hyperlink properties of the control as you
have them now. This should work.

Myself, and many others, do not use the hyperlink field in tables at all for
this and a few other reasons. The internal formatting that Access imposes
upon data in these fields is generally a nuisance to developers.

hth

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)

 

[Michael]

Thank you Jack,

I have followed your advice and it's fine using the OnClick event and a text
field.

All the bes,

Michael.