Hyperlink Fields

[Melih]

Hi,

Hope someone has a workaround for this silly problem.

Is there a way to get around the format required for
hyperlinks in Access? The format currently is to enter
displaytext#address#subaddress#screentip

So if the only thing you want to enter is the URL you
have to type #URL##. How do we get around just typing
the URL without having to put the #'s before and after?

Without the #'s the hyperlink does not work. We found,
once we put the # in we can then click on the link and
the browser opens correctly. Without the #'s when you
click nothing happens.

There must be a way around this?

Thanks.

 

[Allen Browne]

The simplest thing it probably just to use a text field instead of a
hyperlink. You can still make it look and behave like a hyperlink in a form.

Alternatively, you could use the AfterUpdate event of an (unbound?) text box
to add the hashes and assign to the field.

Going the other direction, the HyperlinkPart() functions parses it for your.

 

[Dylan Moran]

Allen,

I see you have mentioned ina number of posts "you can use a text field
instead of a

hyperlink. You can still make it look and behave like a hyperlink in a form."

Is there any chance you can post a snippet of your code to do this so I can
insert into a double click event or similar?

P.S. I understand if that is not Ok.

Regards
Dylan