Hyperlink Field Custom Formatting?

[excellenthelp]

Hello Accessers,

I have been researching for about an hour and decided to give up and come here to ask for help.

I have created a hyperlink field with the website urls in them.

What I am trying to achieve is to create another field to automatically convert the hyperlink field into a hyperlink that displays "Website" automatically for every record. I do not want users to type in the URL and then have to fill in another field to display it as 'Website'. Having both fields is important for reporting purposes and form use.

How may I achieve this? I have tried to use calculated field like: =Website# & [WebsiteURL], but to no avail.



Thanks.

[June7]

A hyperlink value has 3 parts. You can break out the 3 parts with string manipulation functions.

Review:

http://www.allenbrowne.com/casu-09.html

http://allenbrowne.com/func-GoHyperlink.html