Link pulled into a Formlula Rich Text not working correctly

Hi Mark, that's great. The link works fine now in a new field [Questionnaire Link for Emails].

The hyperlink isn't working for some reason though, it's just treating the whole formula as part of the url. I've tried creating a new Formula URL field for it too, and that's doing the same thing.

I've tried:

var text Hyperlink = "<a href=" & [Questionniare Link for Emails] & ">" & "Click here" & "</a>"; 

And it's giving an "Expecting Text" error. I've tried it with entering entering the entire URL where [Questionnaire Link for Emails] is and that does the same.

If I delete the semi-colon the error goes away but the link doesn't work.

If I save it with the error it just shows as this:


But the link is broken.

What I've done is the part of the link that changes depending on the record is the Questionnaire ID Text, so in the link for emails I've typed out the URL as you have above, but inserted that field at the point where it needs to change from client to client, then continued with the url free typed beyond that point. So the link for Email is working fine now.

I'll keep having a play around with that, the more important part is the link working.

Thanks a lot for your help with that.

------------------------------
Joe Alderson
------------------------------